Another COUNTIF question

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
 
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
 

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

Similar Threads

Using <= in countifs statement 1
Excel 2003 version of Countifs 3
Key Card Software (Auric) 7
Countif to exclude blanks 3
Copy Matching Numbers To New Cell's 5
COUNTIF does not return the value as I expected 6
Locate text in range (multiple occurrences) and report other cell insame column? 25
Count Number of Unique Cells That Don't Have Certain Characters 0

Top