How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask HandyDan217 Your Own Question
HandyDan217, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 32
Experience:  Microsoft Office is my specialty.
Type Your Microsoft Office Question Here...
HandyDan217 is online now
A new question is answered every 9 seconds

Im creating an Excel 2010 workbook with 20 identical sheets

Resolved Question:

I'm creating an Excel 2010 workbook with 20 identical sheets and a summary page (where info from all 20 sheets are added up). How can I delete unused sheets without getting the #REFERENCE!-message. Can I get the summary sheet to just ignore missing references? /Liza
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  HandyDan217 replied 5 years ago.

HandyDan217 :

Hello! This is possible to do using indirect formulas. Basically creating a separate data table that contains the individual values from the multiple sheets and then using a final formula that uses the ISNUMBER function to filter out any reference errors.


It worked, thanks!

HandyDan217 and 3 other Microsoft Office Specialists are ready to help you