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

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

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

Will something like this work for you?

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

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Dale" wrote:

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

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

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

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

best wishes
Bernard


"Dale" wrote in message
...
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

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

From the spec, that should be =29.

--

HTH

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


"bernard liengme" wrote in message
...
Assuming you really mean COUNT and not ADD;
a) =COUNTIF(A1:A100,"19") - COUNTIF(A1:A100,"29")
b) =SUMPRODUCT(--(A1:A10019), --(A1:A100<29))

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

best wishes
Bernard


"Dale" wrote in message
...
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