=SOMMA.PIÙ.SE($B$2:$B$365;$A$2:$A$365;">="&DATA(2016;4;1);$A$2:$A$365;"<="&DATA(2016;10;31))
=SOMMA.PIÙ.SE($C$2:$C$365;$A$2:$A$365;">="&DATA(2016;4;1);$A$2:$A$365;"<="&DATA(2016;10;31))