Another COUNTIF question

  • Thread starter Thread starter Don Guillett
  • Start date Start date
D

Don Guillett

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

--
Don Guillett
SalesAid Software
(e-mail address removed)
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
 
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
 
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
 
Back
Top