i am using formula
IFERROR(SUM(INDEX(INDIRECT("'"&A2&"'!$C$1:$C$7"),0,MATCH(B2,(INDIRECT("'"&A2&"'!$a$1:$a$7")),0))),0)
indirect represents sheetname. Greatful for your help
i am using formula
IFERROR(SUM(INDEX(INDIRECT("'"&A2&"'!$C$1:$C$7"),0,MATCH(B2,(INDIRECT("'"&A2&"'!$a$1:$a$7")),0))),0)
indirect represents sheetname. Greatful for your help
=IFERROR(SUMIF(INDIRECT("'"&A1&"'!$a$1:$a$20"),B1;INDIRECT("'"&A1&"'!$b$1:$b$20")),"")
Try this formula
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Try this...
Data Range
A B C 1 1104 a 1 2 1104 b 7 3 1104 c 9 4 1104 d 4 5 1104 e 0 6 1104 f 0 7 1104 g 7 8 1204 a 11 9 1204 b 0 10 1204 c 0 11 1204 d 14 12 1204 e 40 13 1204 f 16 14 1204 g 17 15 ------ ------ ------
This formula entered in C1 and copied down:
=IFERROR(SUMIF(INDIRECT("'"&A1&"'!A:A"),B1,INDIRECT("'"&A1&"'!B:B")),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tony Valko answer was correct. It lookd tough but he gave easy solution. Thank you. I am just tracing solved button but could not locate it.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks