Combined Sumif & Sumifs

New Contributor

I need to combine two Sumif & Sumifs formulas or find a soulution with my issue.  Is there another way to solve my dilemma.

clipboard_image_1.png

3 Replies
Highlighted

@mcavas 

Do you mean

=SUMIFS(B23:B28,A23:A28,"<>skip",C23:C28,"pay",B23:B28,"<>0")

?

Highlighted
Thank you for the reply back. However, the formula did not address the Pending column. Within the Combined formula table, when I placed skp in the Pending column, the formula accounted only the Resolute column. In other words, if skp is placed in the Pending column and n/a is placed in the Resolute column, I should end up with a total amount of 4.
Highlighted

@mcavas 

Formula returns 4, please check attached. I'm not sure what "n/a" means for Resolute column, it calculates for Pending <> skp and Resolute=pay