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 speci...
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))