To SUMIF or SUMIFS - Neither are working

Brian Becnel

I am a newbie and I'm stumped. I am trying to calculate the remaining budget for projects that have a ProjPortStat(us) as "active" in a field on the Sheet Summary (I can successfully calculate a single column where the status is "active").

I've tried 100's of permutations of SUMIF and SUMIFS and each time is either UNPARCEABLE or INVALID OPERATION. The below formula is just the latest in my Summary Sheet Field.

=SUMIFS(ProjPortStat:ProjPortStat, "Active", (Budget:Budget - Spend:Spend))

Jason Tarpinian

I think you have to break out the SUMIF to make it work:

=SUMIF(ProjPortStat:ProjPortStat, "Active", Budget:Budget) - SUMIF(ProjPortStat:ProjPortStat, "Active", Spend:Spend)

If someone knows how to do it with one SUMIF function, I'd be interested to see how!

Jason Tarpinian

I think you have to break out the SUMIF to make it work:

=SUMIF(ProjPortStat:ProjPortStat, "Active", Budget:Budget) - SUMIF(ProjPortStat:ProjPortStat, "Active", Spend:Spend)

If someone knows how to do it with one SUMIF function, I'd be interested to see how!

Brian Becnel

Huzzzah!! Thank you! Apparently 101 permutations was needed.