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.