Another COUNTIF question

D

Don Guillett

how about
=sumproduct((L2:L144>2)*(L2:L144<6))

--
Don Guillett
SalesAid Software
[email protected]
David Shore said:
I would like to count the cells that contain a number that occurs between
Click to expand...
two other numbers. For example, cells that would be counted in both of these
situations: =COUNTIF(L2:L144,"<6") and =COUNTIF(L2:L144,">2"). What
formula could I use? Thanks
 
D

David Shore

I would like to count the cells that contain a number that occurs between two other numbers. For example, cells that would be counted in both of these situations: =COUNTIF(L2:L144,"<6") and =COUNTIF(L2:L144,">2"). What formula could I use? Thanks
 
T

Tony Petruzziello

How about this:

=COUNTIF(L2:L144,"<6") - COUNTIF(L2:L144,"<=2")

TonyP

David Shore said:
I would like to count the cells that contain a number that occurs between
Click to expand...
two other numbers. For example, cells that would be counted in both of these
situations: =COUNTIF(L2:L144,"<6") and =COUNTIF(L2:L144,">2"). What
formula could I use? Thanks
 
Top