SumIf works but SumIFs does not?

[jscranton]

This formula works fine:

=SUMIF(I30:I42,">="&I2,G30:G42)

This formula gives me a "#Value!" error:

=SUMIFS(G30:G42,I30:I43,">="&I2)

I have under criteria for the SUMIFs which is why I can use SUMIF but it was erroring out so trying to figure out why.

 

[Marcelo Branco]

=SUMIFS(G30:G42,I30:I43,">="&I2)

Try
=SUMIFS(G30:G42,I30:I42,">="&I2)

M.