I have a range and need to sum it using SUM function but the result is N/A if there is any N/A value. How can I make the SUM function to treat the N/A value as 0 value? Please help!
There is a new function in Excel which will add all the values either positive or negative while ignoring NA's.
=aggregate(9,6, range of your data)
9 is used for sum while 6 is for ignoring all NA's. There are other options, as well, beside addition. For example, you can do product, standard deviation, and so on.
More information on AGGREGATE here.