![]() |
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 |
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 |
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 |
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