Hi guys, I need to know if it is possible to use the index match function (or sumifs maybe?) to sum values across multiple sheets using the same range i.e
i.e.
where the sheet range is April:MarchPlease Login or Register to view this content.
Hi guys, I need to know if it is possible to use the index match function (or sumifs maybe?) to sum values across multiple sheets using the same range i.e
i.e.
where the sheet range is April:MarchPlease Login or Register to view this content.
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential information is removed first!!
4. Try to avoid using merged cells. They cause lots of problems!
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Generic formula ...
=SUMPRODUCT(SUMIF(INDIRECT("'"&sheets&"'!"&"C4:C100"),D6,INDIRECT("'"&sheets&"'!"&"D4:D100")))
Sheets is a named range of your tabs
there are 12 sheets in total a year split between April to March (hence the April:March range provided). The sumproduct would require me to complete it 12 times for each sheet. I am looking to sum column D based on the value of Column C across all 12 of the sheets.
I am looking for the equivalent of the below
Please Login or Register to view this content.
Last edited by Sc0tt1e; 11-23-2017 at 01:24 PM.
Please refer to post 2.
... Reference post #3 and your reply #4: you only need one SUMPRODUCT statement as it SUMS over the "Sheets" range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks