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

D

Dale

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
 
R

Ron Coderre

Will something like this work for you?

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

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

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
 
B

Bob Phillips

From the spec, that should be >=29.

--

HTH

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