Excel if Formula text vs numbers

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