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

G

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top