LinkBack URL
About LinkBacks
use spare column F1: enter 1 then copy down to F150
Create a name range on column F: MySheets
=SUMPRODUCT(SUMIF(INDIRECT("'"&MySheets&"'!B3:B1000"),$B4,INDIRECT("'"&MySheets&"'!D3:D1000")))
use spare column F1: enter 1 then copy down to F150
Create a name range on column F: MySheets
=SUMPRODUCT(SUMIF(INDIRECT("'"&MySheets&"'!B3:B1000"),$B4,INDIRECT("'"&MySheets&"'!D3:D1000")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks