Home » Forums » Open Source Learning Center » Question and Answer

SUMIFS Assistance

Submitted by TexasGinja on 1 May, 2015 - 00:26

Looking for some assistance on a SUMIFS formula. I had copied and pasted from a previous working nearly identical formula.

The ranges are named exactly like the last formula I copied, yet the percentage at the bottom does not change like the last formula did.

What did I miss?

sumifs formula.png
‹ Equalising formula VBA Help please - Idle message pops up whether idle or not, and when file is in 'read-only' or 'notify' status ›
»
Jean-Yves Hemlin's picture

Clarifications

Submitted by Jean-Yves Hemlin on 4 May, 2015 - 21:32.

Not sure to understand what you are trying to do.

You have 6 clients late (in the 5.01 - 11 bracket).

Are you expecting -50% as result?

Via SUMPRODUCT
=SUMPRODUCT((deduction)*((Start)B16))

Via SUMIFS
=SUMIFS(deduction,Start,"<" & B16,End,">" & B16)

=SUMIFS({0,-0.5,-1},{true, true, false},{false, true, true})
=SUMIFS({0,-0,5,-1},{false, TRUE, false})
=SUMIFS({,-0,5,}) ===> -0.5

(You simply had the wrong signs...)

»