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:

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