Helf for CountIfs with combination of AND

M

megv

I want to know how to count the number of cells that have data less than a certain value and greater than another value. It is data that is compared continuously and the data I am using for the comparisons changes every cell

Thanks
 
B

Bob Umlas

=SUMPRODUCT((A1:A100<45)*(A1:A100>22))

Bob Umlas
Excel MVP
megv said:
I want to know how to count the number of cells that have data less than a
Click to expand...
certain value and greater than another value. It is data that is compared
continuously and the data I am using for the comparisons changes every cell.
 
Top