cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel

Danny069
Copper Contributor

‎Apr 12 2019 12:26 AM

‎Apr 12 2019 12:26 AM

Excel

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

Labels:
399 Views
0 Likes
1 Reply
Reply
1 Reply
Jan Karel Pieterse

‎Apr 12 2019 02:00 AM

‎Apr 12 2019 02:00 AM

Re: Excel

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)
0 Likes
Reply