I need a formula which will add up column D,E AND F even with the #N/A since it is not working when summing up with #N/A
Please see attached for screenshot.
Appreciate the help!
I need a formula which will add up column D,E AND F even with the #N/A since it is not working when summing up with #N/A
Please see attached for screenshot.
Appreciate the help!
What formula are you using? SUM should work:
=SUM(D2:F2)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It does not work with #N/A I just tried please see attached for screenshot.
How about attaching the workbook?
I have just solved the problem, I have used this formula- =SUMIF(D2:F2,"<>#N/A")
I appreciate the help!
Great! Well done.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks