'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



Solution 1:[1]

Use AGGREGATE which will ignore the errors:

=AGGREGATE(9,3,A:A)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Scott Craner