Another sumproduct question...with multiple criteria
Hi, so I received an awesome response to my first question about setting up a sumproduct that will copy and paste but I realized as I'm setting up my file I need to be able to reference the row label as well as an additional criteria as I have inserted blank rows in the dept tabs for budget inputs...can anyone assist? Please see my attached example. Thanks again!
The current formula in E7 still appears to correctly collect the total of 1500 for that Hyperion Account. What seems to be the problem?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
The problem is that I have blank rows in the dept files that I do not want to include in the summary files...hopefully someone can help me out
If you have blank rows, then there would be nothing to incluide?
can you give an example of what you mean/what the problem is?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The file I've attached in the post has 2 different department tabs and a summary tab. I need to use the sumproduct to sum across multiple tabs based on whether the dept is NNE or TG and by hyperion account number and then I need to be able to copy and paste over and down. If you look at the dept tabs I have inserted rows in certain accounts that have more detail that I don't want to include on the summary tabs. Let me know if that doesn't make sense.
Last edited by Jessabell75; 07-26-2015 at 06:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks