Sum by Year Index Problem

[fasullo]

Hi, I want to sum a data table by year. How do I do that?

'Summary' tab - lookup Product A in the 'data' tab and sum the monthly expenses of Product A by year.

Sum by Year Index Problem

Summary Description,2020,2021,2022 Product A,449,914,885,828,221,457 Product B,265,774,1,440,296,0 Product C,52,000,0,0

docs.google.com

 

[steve the fish]

Try this:

=SUMIFS(INDEX(Data!$B$2:$Z$4,MATCH($A2,Data!$A$2:$A$4,0),0),Data!$B$1:$Z$1,">="&DATE(B$1,1,1),Data!$B$1:$Z$1,"<"&DATE(B$1+1,1,1))

 

[fasullo]

=SUMIFS(INDEX(Data!$B$2:$Z$4,MATCH($A2,Data!$A$2:$A$4,0),0),Data!$B$1:$Z$1,">="&DATE(B$1,1,1),Data!$B$1:$Z$1,"<"&DATE(B$1+1,1,1))

thanks! that worked