Excel if Formula text vs numbers

NW - Sep 25, 2011 at 07:08 PM
 NW - Sep 25, 2011 at 11:16 PM

I am trying to run an If formula that if the cell range contain text then use Counta but if cells contain number use Sum. At present I'm using:

Only issue I have is that some of the number cells equal 0 (due to formulas in the cells), which are then processed with Counta, but if I use >=0 it no longer counts the text cells

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 25, 2011 at 10:37 PM
"cell range contain text"
you mean by this all the cells in the range are either text or number and no mixed entries.

suppose your range is A1:A10 then use this formula


change the range to suit you.
Thanks works perfect!