count a number that is less than a number and greater than a numbe

[Guest]

How do i do this? I want to count numbers is a range of cells that is greater
than 19 and less than 29.

Thanks

 

[Guest]

Will something like this work for you?

=COUNTIF(A1:A100,"<29") -COUNTIF(A1:A100,"<=19")

••••••••••
Regards,
Ron

 

[bernard liengme]

Assuming you really mean COUNT and not ADD;
a) =COUNTIF(A1:A100,">19") - COUNTIF(A1:A100,">29")
b) =SUMPRODUCT(--(A1:A100>19), --(A1:A100<29))

but if you do want to sum:
a) =SUMIF(A1:A100,">19") - SUMIF(A1:A100,">29")
b) =SUMPRODUCT(--(A1:A100>19), --(A1:A100<29), A1:A100)

best wishes
Bernard

 

[Bob Phillips]

From the spec, that should be >=29.

--

HTH

RP
(remove nothere from the email address if mailing direct)