Forum Discussion
Sumifs
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
1 Reply
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))
