Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-443090%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443090%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Excel%20can%20I%20add%20all%20populated%20non-numerical%20cells%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-443090%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Danny069
Occasional Visitor

In Excel can I add all populated non-numerical cells? 

1 Reply
Highlighted
Do you mean count how many of them there are? (You cannot add non-numeric values)

This formula counts how many items there are which Excel thinks are not numbers, nor dates:

=COUNTA(A1:A100)-COUNT(A1:A100)
Related Conversations
Please Help debug my matrix formula
Katharina_Stemmer1989 in Excel on
0 Replies
Linking external source (eg Share Price) to a cell
Aitch1964 in Excel on
0 Replies
Insert an image in Excel header
mat74 in Excel on
1 Replies
DAX Powerpivot - How to solve this problem in PowerPivot
kayyeah11 in Excel on
0 Replies
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies