CODEWITHSUNDEEP
excel
Blind Blake
Blind Blake

Reputation: 51

how do I add up the whole column in excel?

how do I add up the whole column in excel if there are N/A values?

I cant seem to find a solution to enable me to omit the N/A values as it keeps returning an error

Upvotes: 0

Views: 45

Answers (1)

Scott Craner
Scott Craner

Reputation: 152585

Use AGGREGATE which will ignore the errors:

=AGGREGATE(9,3,A:A)

Upvotes: 1

Related Questions