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
Danny069
Occasional Visitor

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

1 Reply
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)