Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Just change the sequence of parameters - even the parameters should be ranges of the same size as the range of summation, and the odd ones should be the selection conditions.

=SUMIFS($ADDITIONAL.H4:H8,ADDITIONAL.F4:F8,"<=" & E2,$ADDITIONAL.G4:G8,">=" & E2)

Just change the sequence of parameters - even the parameters should be ranges of the same size as the range of summation, and the odd ones should be the selection conditions.

=SUMIFS($ADDITIONAL.H4:H8,ADDITIONAL.F4:F8,"<=" =SUMIFS($ADDITIONAL.H4:H8; ADDITIONAL.F4:F8; "<=" & E2,$ADDITIONAL.G4:G8,">=" E2; $ADDITIONAL.G4:G8; ">=" & E2)