Excel if Formula text vs numbers
Solved/Closed
Related:
- Excel if Formula text vs numbers
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Number to words in excel formula - Guide
- Transfer data from one excel worksheet to another automatically - Guide
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
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