Home |
Search |
Today's Posts |
#1
|
|||
|
|||
simple countif
I have values in cells B2:B8. In cell B10, I woud like a formula that counts
the number of cells in B2:B9 with values greater than 4. Thanks for your assistance. |
#2
|
|||
|
|||
Brian,
This formula should work: =COUNTIF(B2:B9,"4") ---- Regards, John Mansfield http://www.pdbook.com "Brian" wrote: I have values in cells B2:B8. In cell B10, I woud like a formula that counts the number of cells in B2:B9 with values greater than 4. Thanks for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions | |||
Countif, Sumif, If - help! | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |