SumIfs based on Value <

[gheyman]

I am trying to do a type of SumIfs.

My formula is going in K3 (and will be copied down to the end of the sheet)

If the Value in Column $B:$B matches the Value in $B3 and the Value in $F:$F matches the Value in $D3 AND the Value $I:$I is less than the value in $I3

 

[gheyman]

Instead, I can use a SumIfs like above but i need my last condition to be 1 less than

=SUMIFS(W:W,V:V,T5,S:S,S5,U:U,U5&"-1") This is just an example - it doesn't work. I am trying to sum if the value in U is 1 less than the value in U5

 

[Jeffrey Mahoney]

You didn't specify the column you want to sum. How about this:

=SUMIFS(Range to sum,$B:$B,$B3,$F:$F,$D3,$I:$I,"<"&I3)

 

[Jeffrey Mahoney]

=sumifs(w:w,v:v,t5,s:s,s5,u:u,u5-1)