The One Formula

[Workbook]

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.

 

[Domenic]

Can you provide a small sample of the data (about five rows), along with
the actual expected result?

http://www.xl-central.com

 

[Don Guillett]

This is an ARRAY formula that must be entered using ctrl + shift+enter

=COUNT(IF(ISNUMBER(c4:c46),c4:c46))

 

[Mike H]

Try

=SUMPRODUCT(--ISNUMBER(C4:C46))

Mike

 

[Mike H]

Hmmm

=COUNT(C4:C46)

Mike

Try

=SUMPRODUCT(--ISNUMBER(C4:C46))

Mike

 

[Bassman62]

Nice ;-)

Hmmm

=COUNT(C4:C46)

Mike

 

[Workbook]

I think I made a mistake in my explanation. Thank you very much for your
help! Because I think it you interpret what I said differently this formula
does exactly what I asked. =COUNT(IF(ISNUMBER(c4:c46),c4:c46)) returns a 1

 

[Workbook]

Works like a charm! thanks for you're help!

Try

=SUMPRODUCT(--ISNUMBER(C4:C46))

Mike

 

[Workbook]

Even more simple and also works great! Thank you