Hi Team,
I need help in attached sheet for sumifs condition.
my criteria is one vertical and one horizontal so the formula getting error in column "D3" in sheet 2 tab.
Thanks
Hi Team,
I need help in attached sheet for sumifs condition.
my criteria is one vertical and one horizontal so the formula getting error in column "D3" in sheet 2 tab.
Thanks
Hi,
Try this in D3 and then pull down and across
=SUMIFS(Data!$E$4:$E$35,Data!$C$4:$C$35,Sheet2!$C3,Data!$D$4:$D$35,Sheet2!D$2)
SumIfs for rchure.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks