Sumifs

[Rfire777]

Hi guys! 

Requesting for help to provide the solution of sumifs with two match criteria horizontally and vertically both as shown in image which is sharing here...

1) need sum of Rajasthan on specific date 

2) need sum of Rajasthan vertically and horizontally from to given date

Please provide the best solution guys

[#2]

@Rfire777 

1) =SUMPRODUCT($E$2:$H$6, ($C$2:$C$6=$B14)*($E$1:$H$1=C$13))

2) Enter 29/03/2023 in D13.

=SUMPRODUCT($E$2:$H$6, ($C$2:$C$6=$B17)*($E$1:$H$1>=C$13)*($E$1:$H$1<=D$13))