Excel Q - SUM with 2-D array

Question

I have a 2-dimensional array: dates on the horizontal axis and ID numbers on the vertical axis.

I want the amounts to be determined by a specific date and identifier, and I want to know how to do this using SUM.

For some reason, it seems like I can't, as the array is 2-D and the criteria ranges are 1-D. Can someone give me advice on other formulas that I can use?

In other words, I would like to add values ​​that match the selected ID and date; There is one or more data points that satisfy the conditions. This is why the SUMIF function is important.

Answer 1

SUMIF. , :

=SUM(IF($B$2:$B$6=C9,IF($F$1:$K$1=B9,$F$2:$K$6)))

, , , , CTRL + SHIFT + ENTER. , CTRL + SHIFT + ENTER:

=SUMPRODUCT(($B$2:$B$6=C9)*($F$1:$K$1=B9)*$F$2:$K$6)

Answer 2

, , :

=INDIRECT(ADDRESS(MATCH([ID Number],A:A,0),MATCH([Date],1:1,0)))

INDIRECT

ADDRESS

MATCH , .