Get instant live expert help on I need help with excel sum from multiple sheets

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

WHY WON'T =SUM(DAY 1:DAY 31!D2) WORK IN EXCEL TO SUM D2 FROM MULTIPLE SHEETS IN MY WORK BOOK
Solved by D. Q. in 21 mins
I want to know how to sum a range across multiple excel sheets and have that appear on another excel sheet.
Solved by T. H. in 24 mins
I have a work book with multiple sheets. I need to search all sheets for specific text, and sum the quantities. This is an estimate form with multiple sheet that I am trying to generate a Bill of Material from the data on these multiple sheets.
Solved by K. J. in 19 mins
I am trying to sum one particular cell (D3) from multiple sheets in excel. My sheet names are 1 through 3. The formula I am using is =SUM('1:3'!D3) but the total I am getting is adding to 0.00 which is incorrect. What am I doing wrong?
Solved by Z. J. in 19 mins
Automatic report generation from multiple sheets.
Solved by C. C. in 28 mins