Help with Sumifs

MoJones

Hello. Hope everyone is well. I'm having issues with a =SUMIF OR =SUMIFS formula

=SUMIFS({Fed Admin FTE Usage}, >0, {Employment Status}, "On-Board")

I'm getting invalid operation. Please help.

MoJones

Ok. I figured this one out - =SUMIFS({Fed Admin FTE Usage}, {Employment Status}, "On-Board")

But now I have another issue =SUMIFS({Program FTE Usage}, {Victims of Torture}, {Employment Status}, "On-Board")

Any ideas?

Paul Newcome

You are missing the criteria for the second range:

=SUMIFS({Program FTE Usage}, {Victims of Torture}, {Employment Status}, "On-Board")

MoJones

Trying to add program FTE Usage and Victims of Torture but only if the employment status is "On-Board" not sure what I'm missing here.

Jeff M.

Hi,

This method might work for you as well. Hope that helps!

=SUMIF({Employment Status}, "On-Board", {Program FTE Usage}) + SUMIF({Employment Status}, "On-Board", {Victims of Torture})