Sum(Indirect())

Hello,

I have a worksheet that has the user ask how many stages they need on “Stage1” worksheet and then stage1 worksheet is copied.

I have a formula on another worksheet “MaterialCalculation” where I am trying to sum(indirect()) the amount of materials needed. I created this function when I had asked for 30 stages but when I tried it again and used 6 stages I got the #REF! error.

I have been working on this a while so any help would be greatly appreciated! Thank you!

=SUMIF(INDIRECT(“Stage1!$C$6:$C$18”),$A5,INDIRECT(“Stage1!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage2!$C$6:$C$18”),$A5,INDIRECT(“Stage2!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage3!$C$6:$C$18”),$A5,INDIRECT(“Stage3!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage4!$C$6:$C$18”),$A5,INDIRECT(“Stage4!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage5!$C$6:$C$18”),$A5,INDIRECT(“Stage5!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage6!$C$6:$C$18”),$A5,INDIRECT(“Stage6!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage7!$C$6:$C$18”),$A5,INDIRECT(“Stage7!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage8!$C$6:$C$18”),$A5,INDIRECT(“Stage8!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage9!$C$6:$C$18”),$A5,INDIRECT(“Stage9!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage10!$C$6:$C$18”),$A5,INDIRECT(“Stage10!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage11!$C$6:$C$18”),$A5,INDIRECT(“Stage11!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage12!$C$6:$C$18”),$A5,INDIRECT(“Stage12!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage13!$C$6:$C$18”),$A5,INDIRECT(“Stage13!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage14!$C$6:$C$18”),$A5,INDIRECT(“Stage14!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage15!$C$6:$C$18”),$A5,INDIRECT(“Stage15!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage16!$C$6:$C$18”),$A5,INDIRECT(“Stage16!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage17!$C$6:$C$18”),$A5,INDIRECT(“Stage17!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage18!$C$6:$C$18”),$A5,INDIRECT(“Stage18!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage19!$C$6:$C$18”),$A5,INDIRECT(“Stage19!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage20!$C$6:$C$18”),$A5,INDIRECT(“Stage20!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage21!$C$6:$C$18”),$A5,INDIRECT(“Stage21!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage22!$C$6:$C$18”),$A5,INDIRECT(“Stage22!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage23!$C$6:$C$18”),$A5,INDIRECT(“Stage23!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage24!$C$6:$C$18”),$A5,INDIRECT(“Stage24!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage25!$C$6:$C$18”),$A5,INDIRECT(“Stage25!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage26!$C$6:$C$18”),$A5,INDIRECT(“Stage26!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage27!$C$6:$C$18”),$A5,INDIRECT(“Stage27!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage28!$C$6:$C$18”),$A5,INDIRECT(“Stage28!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage29!$C$6:$C$18”),$A5,INDIRECT(“Stage29!$E$6:$E$18”))+SUMIF(INDIRECT(“Stage30!$C$6:$C$18”),$A5,INDIRECT(“Stage30!$E$6:$E$18”))

By: Rose Currie

23 thoughts on “Sum(Indirect())

  1. Buy Melanotan 2 online

    Very good blog you have here but I was wanting to know if you knew of any message boards that cover the same topics discussed in this article? I’d really like to be a part of community where I can get responses from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Cheers!

  2. anabolika kaufen

    Unquestionably believe that which you stated. Your favorite justification appeared to be on the web the easiest thing to be aware of. I say to you, I definitely get irked while people consider worries that they plainly do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people can take a signal. Will likely be back to get more. Thanks

  3. sibutramin kaufen

    Awsome info and straight to the point. I don’t know if this is really the best place to ask but do you folks have any ideea where to get some professional writers? Thanks in advance 🙂

  4. Kaufen

    Thank you for the good writeup. It if truth be told was once a entertainment account it. Glance advanced to more delivered agreeable from you! However, how can we keep in touch?

  5. view

    Hi, Neat post. There is an issue together with your website in internet explorer, would test thisK IE still is the marketplace leader and a huge portion of other people will leave out your magnificent writing because of this problem.

  6. WaynePaymn

    Choose enlightening looking forth to coming in return. [url=http://de.detoxyn.org/stationare-entgiftung-alkohol-berlin/]http://de.detoxyn.org/stationare-entgiftung-alkohol-berlin/[/url]

  7. Buy Gabapentin

    hey there and thank you for your info – I’ve definitely picked up something new from right here. I did however expertise a few technical issues using this web site, as I experienced to reload the site many times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I am complaining, but sluggish loading instances times will often affect your placement in google and can damage your high quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and could look out for a lot more of your respective exciting content. Ensure that you update this again soon..

  8. Natisha Jovanovich

    Youre so cool! I dont suppose Ive learn something like this before. So nice to find somebody with some original thoughts on this subject. realy thanks for beginning this up. this website is one thing that is needed on the web, someone with a bit originality. useful job for bringing one thing new to the internet!

Comments are closed.