Solved

Formula I'm using

Posted on 2015-02-24
5
70 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:pedwards3
  • 2
  • 2
5 Comments
 
LVL 33

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 25

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:pedwards3
ID: 40628628
All,

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

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

Accepted Solution

by:
Norie earned 500 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:pedwards3
ID: 40628956
Thanks.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

770 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