ExcelBanter - simple countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - simple countif (https://www.excelbanter.com/excel-worksheet-functions/11316-simple-countif.html)

Brian

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.

John Mansfield

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.

All times are GMT +1. The time now is 10:26 PM.