Can't figure out dates - SUMIFS or SUMPRODUCT?

[vegaaltair]

Hello,

I have an issue in getting excel to sum a range beginning at Jan-17 up to and including the current month that will auto update ongoing e.g. next month it will include Jan17-Mar17. I can only seem to have it sum just Jan-17 is it best to use sumifs or sumproduct? Will the formatting of row 1 matter as these are calculated using Edate formula and formatted to mmm-yy

Any help would be greatly appreciated

 

[wideboydixon]

Try this in O3 and copy down:

=SUMPRODUCT(($B$1:$N$1>=DATE(2017,1,1))*($B$1:$N$1<=TODAY()),$B3:$N3)

WBD

 

[vegaaltair]

Thanks alot, worked like a charm.