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.
[TABLE="class: grid, width: 576"]
<tbody>[TR]
[TD]Type[/TD]
[TD]Dec-19[/TD]
[TD]Sep-20[/TD]
[TD]Jun-21[/TD]
[TD]Mar-22[/TD]
[TD]Dec-22[/TD]
[TD]Jun-23[/TD]
[TD]Jun-24[/TD]
[TD]Jun-25[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD] 73[/TD]
[TD] 35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD] 38[/TD]
[TD] 74[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 74[/TD]
[TD] 56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD] 44[/TD]
[TD] 8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD] 36[/TD]
[TD] 45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 51[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 1[/TD]
[TD] 52[/TD]
[TD] 52[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 32[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 22[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 25[/TD]
[TD] 25[/TD]
[TD] 25[/TD]
[TD] 25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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))