Jul 11 2019 02:17 AM
Hello everybody.
I guess this is a very elementary question but I'm not able to find the right grammar to do it. So, I have a column of dates and an adjacent column of numbers. I would like to sum the numbers relevant to the same month, let's say june for example.
thanks a lot
Francesco
Jul 11 2019 02:51 AM
As one of variants that could be like
=SUMIFS(B:B,A:A,">="&DATE(2019,6,1),A:A,"<"&DATE(2019,7,1))
where year and month better keep as parameters