Sumproduct Multiple Criteria YTD

[kherder7]

Hello there,
I have multiple criteria in A4:A12 & B4:B12, months in D3:O3, and data in D4:O12. With a month identifier in cell A1(ex. 'Jun21), how can I use Sumproduct to get YTD values for multiple criteria? Any help would be greatly appreciated.

Cheers!
Kyle

 

[Fluff]

Hi & welcome to MrExcel.
Are the values in row 3 & A1 actual dates formatted to show "mmmyy" or are they text values?
Also for the YTD are you still wanting to use the value in A1 to determine which is the last column to look at?

 

[Snakehips]

As long as they are consistent (date or text) then, I think below formula in S4 and dragged down should do?

=SUMPRODUCT(($C$4:$C$12=$Q4)*(OFFSET($D$4:$O$12,,,,MATCH($A$1,$D$3:$O$3,0))))

Hope that helps.

 

[Fluff]

Another possible option

=SUMPRODUCT(($C$4:$C$12=Q4)*($D$4:INDEX($D$4:$O$12,,MATCH($A$1,$D$3:$O$3,0))))