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.