how do I add up the whole column in excel?-CodePudding

Home > OS > how do I add up the whole column in excel?

how do I add up the whole column in excel?

Time：03-25

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

CodePudding user response：

Use AGGREGATE which will ignore the errors:

=AGGREGATE(9,3,A:A)