Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif Between
I need to count how many cells in column D have a value in them between 7 and
3. I cant find anything that lets me use between as criteria and Countif only allows me to have 1 criteria. Any ideas? |
#2
|
|||
|
|||
Here are 3 possible ways (inclusive):
=COUNTIF(D1:D100,"=3")-COUNTIF(D1:D100,"7") =SUMPRODUCT(--(D1:D100=3),--(D1:D100<=7)) =COUNT(D1:D100)-SUM(COUNTIF(D1:D100,{"<3","7"})) HTH Jason Atlanta, GA -----Original Message----- I need to count how many cells in column D have a value in them between 7 and 3. I cant find anything that lets me use between as criteria and Countif only allows me to have 1 criteria. Any ideas? . |
#3
|
|||
|
|||
Hi Alex
here's two methods =SUMPRODUCT(--(D3:D353),--(D3:D35<7)) =COUNTIF(D3:D35,""&3)-COUNTIF(D3:D35,""&6) Cheers JulieD "Alex" wrote in message ... I need to count how many cells in column D have a value in them between 7 and 3. I cant find anything that lets me use between as criteria and Countif only allows me to have 1 criteria. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Countif | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
Countif ??? | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |