I need a formula to extract some values which are available in different sheets (East, West, North).
There are 2 criteria- one is the sheet name and another is the month. Also, I will add more sheets in future and the extraction should happen in that way.
Attached sheet FYR.
in C6
=SUMPRODUCT((INDIRECT("'"&$C$4&"'!B2:z100")*((INDIRECT("'"&$C$4&"'!A2:A100")=$B6))))
in F6
=SUMPRODUCT((INDIRECT("'"&$C$4&"'!B2:z100")*((INDIRECT("'"&$C$4&"'!A2:A100")=$E6)))*((INDIRECT("'"&$C$4&"'!B1:z1")=$F$4)))
Perfect. Thanks a ton.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks