[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Formula I'm using

Posted on 2015-02-24
5
Medium Priority
?
91 Views
Last Modified: 2015-02-24
Why is my formula not working?  Please be specific, and explain why so I can apply on my own going forward.

Thanks
Book2.xlsx
0
Comment
Question by:Pete Edwards
  • 2
  • 2
5 Comments
 
LVL 36

Expert Comment

by:Norie
ID: 40628560
You can't refer to multiple worksheets/ranges like this.

501105'!$C$2:$C$200","30163-001AE'!$C$2:$C$200","30382-001AB'!$C$2:$C$200

What are you trying to calculate with the formula.
0
 
LVL 27

Expert Comment

by:ProfessorJimJam
ID: 40628587
I also did not understand the requirement.

not sure if this works . untested  see this formula =SUMPRODUCT(SUMIF(INDIRECT("'"&workorders&"'!"&CELL("address",C2)&":"&CELL("address",C200)),A16,INDIRECT("'"&workorders&"'!"&CELL("address",D2)&":"&CELL("address",D200))))
0
 

Author Comment

by:Pete Edwards
ID: 40628628
All,

I have had an expert previously have it work for me.

Please see attached.
EE-Formula-III.xls
0
 
LVL 36

Accepted Solution

by:
Norie earned 2000 total points
ID: 40628641
Oops, my mistake.

Try this, you were missing a single quote in front of the sheet names.

=SUMPRODUCT(SUMIF(INDIRECT("'"&workorders&"'!$C$2:$C$200"),A16,INDIRECT("'"&workorders&"'!$D$2:$D$200")))
0
 

Author Closing Comment

by:Pete Edwards
ID: 40628956
Thanks.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question