Excel if Formula text vs numbers
Solved/Closed
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
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:
- Excel if Formula text vs numbers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 25, 2011 at 10:37 PM
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.
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.
Sep 25, 2011 at 11:16 PM