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 Robert M. Your Own Question

Robert M.
Robert M., Consultant
Category: Financial Software
Satisfied Customers: 2630
Experience:  30 yrs. of computer experience in financial and marketing departments.
Type Your Financial Software Question Here...
Robert M. is online now
A new question is answered every 9 seconds

I have 500 sheets in one workbook. They were created with

Customer Question

I have 500 sheets in one workbook.  They were created with a template so all cell references are in the same position on every sheet.  I need to compile stats from the sheets.  I have reports set up in another sheet of the same workbook.  I need the reports to calculate the information in the other 500 sheets. For example:  Report #1 compiles stats for the month of January from the 500 sheets, but I need it to ONLY compile that info from the sheets that have activity in January.  So lets say I set a cell to have an “x”entered into it to indicate that this sheet has January activity.  When that box has an “x” entered then the formula will compile the info needed from other cells in the sheet.  If no “x” then ignore that sheet.  How do I do that?

Submitted: 1 year ago.
Category: Financial Software
Expert:  Rachel-Mod replied 1 year ago.
Hello,
I'm a moderator for this topic. I've been working hard to find a professionals to assist you with your question , but sometimes finding the right professionals can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!
Customer: replied 1 year ago.


I will wait. I need to know how to do this.

Expert:  Rachel-Mod replied 1 year ago.
Thank you for your patience. We will continue the search for a professional for you.
Rachel
Customer: replied 1 year ago.


never mind. I figured it out. maybe should cancel my subscription

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
< Last | Next >
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
  • I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight. Bonnie Chesnee, SC
  • Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation. John Minneapolis, MN
  • Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with. Orville Hesperia, California
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Robert M.

    Consultant

    Satisfied Customers:

    2624
    30 yrs. of computer experience in financial and marketing departments.
< Last | Next >
  • http://ww2.justanswer.com/uploads/flopcat98/2009-11-02_004348_rob_suit.JPG Robert M.'s Avatar

    Robert M.

    Consultant

    Satisfied Customers:

    2624
    30 yrs. of computer experience in financial and marketing departments.
  • http://ww2.justanswer.com/uploads/DF/dfmcpa7691/2011-1-9_14443_mainprofileimage.64x64.jpg Doug Millington's Avatar

    Doug Millington

    Certified Public Accountant (CPA)

    Satisfied Customers:

    268
    Bachelor of Science Cornell University 1979 - CPA since 1981 - Certified QuickBooks ProAdvisor - 30+ years experience.
  • http://ww2.justanswer.com/uploads/BB/bbl242003/2010-12-15_24730_mr.BruceBecker.jpg bbl242003's Avatar

    bbl242003

    Accountant

    Satisfied Customers:

    182
    MBA
  • http://ww2.justanswer.com/uploads/AN/AnswerCPA/2011-9-25_161544_Photoprofessionalportraitseptia.64x64.jpg AnswerCPA's Avatar

    AnswerCPA

    Advisor

    Satisfied Customers:

    175
    QuickBooks Pro Advisor
  • http://ww2.justanswer.com/uploads/Leanne0424/2010-09-06_222047_Just_Answer.jpg Leanne Stewart's Avatar

    Leanne Stewart

    Quickbooks Pro Certified

    Satisfied Customers:

    153
    QuickBooks certified, in my own business for 7+ years.
  • http://ww2.justanswer.com/uploads/Welltor/2010-04-30_122105_welltor.jpg David Bennett's Avatar

    David Bennett

    Certified QuickBooks ProAdvisor

    Satisfied Customers:

    91
    16+ yrs exper. QuickBooks Specialist, contract accounting technician, consultant & trainer!
  • http://ww2.justanswer.com/uploads/JG/jgordosea/2012-6-7_43138_GordosVeritas.64x64.jpg jgordosea's Avatar

    jgordosea

    Enrolled Agent

    Satisfied Customers:

    75
    Three years as Expert support for Turbotax Ask a Tax Expert, Quickbooks support and use >6 yrs