Thread: Calculations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pietro Pietro is offline
external usenet poster
 
Posts: 62
Default Calculations

Could anybody help me to solve these problems :
1-I want to use COUNT function to count fields from (B297:B316) If
(B297:B316)=0,but actually ,althogh the fields are empty ,all he fields are
counted,because Excel consideres 0 as a default value for the fields.
2-What's the ode the i should use to count the fields from (B297:B316) if
the value is more than 0 and less than 30 ?