Dynamic formula for summing multiple rows and columns

[atlanticdam]

Hello forum, I'm trying to figure out a dynamic formula that will sum all A that is between 1/2019 and 12/2021. Answer should be 220. Would appreciate any pointers.

Type	Dec-19	Sep-20	Jun-21	Mar-22	Dec-22	Jun-23	Jun-24	Jun-25
A	73	35
A		38	74
B				74	56
B	44	8
B		36	45
B				24
B					33
C					51
C					1	52	52
C								32
C								22
D					25	25	25	25

<tbody>
</tbody>

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF($B$1:$I$1>=K2,IF($B$1:$I$1<=K3,IF($A$2:$A$13=K1,$B$2:$I$13))))

where K2 is 1/2019, K3 12/2021, and K1 A.

 

[atlanticdam]

I don't fully understand how the arguments, but it worked like a charm, thanks.

Would it be possible to construct a formula using "Sumif" or "Sumifs"?

 

[Aladin Akyurek]

I don't fully understand how the arguments, but it worked like a charm, thanks.

You are welcome. It's an array-processing formula.

Would it be possible to construct a formula using "Sumif" or "Sumifs"?

No. The data you have requires array-processing. That is,

either, confirmed with control+shift+enter...

=SUM(IF($B$1:$I$1>=K2,IF($B$1:$I$1<=K3,IF($A$2:$A$13=K1,$B$2:$I$13))))

or, confirmed with enter...

=SUMPRODUCT($B$2:$I$13,($B$1:$I$1>=K2)*($B$1:$I$1<=K3)*($A$2:$A$13=K1))