| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The One Formula
Even more simple and also works great! Thank you
"Mike H" wrote: Hmmm =COUNT(C4:C46) Mike "Mike H" wrote: Try =SUMPRODUCT(--ISNUMBER(C4:C46)) Mike "Workbook" wrote: I am using this formula =SUM(C4:C46) however I want to change it so that it counts any number in its range such as the number 2, 3, 4, 5, etc as a 1, including the actual number 1. |
Threaded Mode
