ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I need to count numbers in cells (https://www.excelbanter.com/excel-worksheet-functions/222844-i-need-count-numbers-cells.html)

j5b9721

I need to count numbers in cells
 
I need to count how many times a number shows up in range of cells

The number I need to find & count is "36"

The range is E4 to I218



T. Valko

I need to count numbers in cells
 
Try this:

=COUNTIF(E4:I218,36)

--
Biff
Microsoft Excel MVP


"j5b9721" wrote in message
...
I need to count how many times a number shows up in range of cells

The number I need to find & count is "36"

The range is E4 to I218





j5b9721

I need to count numbers in cells
 
Thanks!!!! that worked....

"T. Valko" wrote:

Try this:

=COUNTIF(E4:I218,36)

--
Biff
Microsoft Excel MVP


"j5b9721" wrote in message
...
I need to count how many times a number shows up in range of cells

The number I need to find & count is "36"

The range is E4 to I218






T. Valko

I need to count numbers in cells
 
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"j5b9721" wrote in message
...
Thanks!!!! that worked....

"T. Valko" wrote:

Try this:

=COUNTIF(E4:I218,36)

--
Biff
Microsoft Excel MVP


"j5b9721" wrote in message
...
I need to count how many times a number shows up in range of cells

The number I need to find & count is "36"

The range is E4 to I218









All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com