Hi Friends
I need a formula to get department total for each company from the sample attached data. I need to put the formula in the sheet "DEPT" Colum "F"
Hope someone can help me on this.
Thanks
Hi Friends
I need a formula to get department total for each company from the sample attached data. I need to put the formula in the sheet "DEPT" Colum "F"
Hope someone can help me on this.
Thanks
Appreciate clicking the * Add Reputation button on your left side, if you want say thanks to me
DEPT
F4=SUMPRODUCT((MAIN!$B$2:$B$4=DEPT!$B4)*(MAIN!$C$2:$C$4=DEPT!$C4)*(MAIN!$N$1:$P$1=DEPT!$E4)*(MAIN!$D$2:$D$4=DEPT!$D4)*(MAIN!$N$2:$P$4))
Copy down
F4 cell array formula, drag down
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks