Sumproduct across multiple tabs
Hey all...I am trying to sum across multiple sheets based on a criteria which I can get to work...the problem is I can't then copy the formula? I've tried to research but I'm missing it. I've attached a workbook example. Thanks so much for any assistance!
The formula's will work (see the green cells).
I can't get it to work to work the formula across (see the red text => is wrong answer).
Which is also your question
Maybe another forummember can sort this out.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You'll need to change the references in the second INDIRECT formula to move together with the rows and columns as you copy across.
i.e.
Formula:
Please Login or Register to view this content.
Ah! That worked!!!!!!!!!! Thanks so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks