The One Formula
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.
|