LinkBack URL
About LinkBacks
Try...
B2, copied down:
=SUMPRODUCT(SUMIF(INDIRECT("'"&$D$2:$D$5&"'!D:D"),A2,INDIRECT("'"&$D$2:$D$5&"'!F:F")))
...where A2 contains the 'concept' of interest, and D2:D5 contains your sheet names.
Hope this helps!
Try...
B2, copied down:
=SUMPRODUCT(SUMIF(INDIRECT("'"&$D$2:$D$5&"'!D:D"),A2,INDIRECT("'"&$D$2:$D$5&"'!F:F")))
...where A2 contains the 'concept' of interest, and D2:D5 contains your sheet names.
Hope this helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks