Calculations
Not working !!!!!!
"Toppers" wrote:
=SUMPRODUCT((B297:B3160)*(B297:B316)<30))
"Pietro" wrote:
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 ?
|