Previous Topic Next Topic

Excel if Formula text vs numbers

Solved/Closed
NW - Sep 25, 2011 at 07:08 PM
 NW - Sep 25, 2011 at 11:16 PM
Hello,

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:
=IF(SUM(G47:BG47)>0,SUM(G47:BG47),COUNTA(G47:BG47))

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

Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

=IF(COUNTA(A1:A10)=COUNT(A1:A10),SUM(A1:A10),COUNTA(A1:A10))

change the range to suit you.
0
NW
Sep 25, 2011 at 11:16 PM
Thanks works perfect!
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response