# Excel if Formula text vs numbers

Solved/Closed
Related:

- Excel if Formula text vs numbers
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - 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