LinkBack URL
About LinkBacks
Hello Experts,
I need a sum formula that will sum a range of cells that has in #NA error message or any other error message. I am however mainly concern about the #NA error message.
Thanks,
Headley
Hello Experts,
I need a sum formula that will sum a range of cells that has in #NA error message or any other error message. I am however mainly concern about the #NA error message.
Thanks,
Headley
Hi.
If the non-error values in that range are only non-negative:
=SUMIF(A1:A10,">=0")
If there could be negative values as well:
=SUM(SUMIF(A1:A10,{">=","<"}&0))
Regards
This works if you only have #NA errors:Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks