# sum using indirect index match

1. ## sum using indirect index match

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

2. ## Re: sum using indirect index match

=IFERROR(SUMIF(INDIRECT("'"&A1&"'!\$a\$1:\$a\$20"),B1;INDIRECT("'"&A1&"'!\$b\$1:\$b\$20")),"")

Try this formula

3. ## Re: sum using indirect index match

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")),"")

4. ## Re: sum using indirect index match

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.

5. ## Re: sum using indirect index match

You're welcome. Thanks for the feedback!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1