Hello,
I need to sum the values in a group, but ignore the NAs. Not considering NAs, this formula works perfectly:
SUMIF(A:A,A2,B:B)
I just need to figure out how to include the syntax for "ignore NA values. Please help!
Thank you.
Hello,
I need to sum the values in a group, but ignore the NAs. Not considering NAs, this formula works perfectly:
SUMIF(A:A,A2,B:B)
I just need to figure out how to include the syntax for "ignore NA values. Please help!
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks