LinkBack URL
About LinkBacks
You can go with Sumifs function too.
Try
Formula:
=IFERROR(SUMIFS(INDEX('Raw Data Sheet'!$I$7:$Z$1642,,MATCH(F$4,'Raw Data Sheet'!$I$5:$Z$5,0)),'Raw Data Sheet'!$H$7:$H$1642,F$1,'Raw Data Sheet'!$A$7:$A$1642,$E5),0)
You can go with Sumifs function too.
Try
Formula:=IFERROR(SUMIFS(INDEX('Raw Data Sheet'!$I$7:$Z$1642,,MATCH(F$4,'Raw Data Sheet'!$I$5:$Z$5,0)),'Raw Data Sheet'!$H$7:$H$1642,F$1,'Raw Data Sheet'!$A$7:$A$1642,$E5),0)
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks