I am trying to determine total "Sales" based on various combinations of three drop down boxes.
For instance, What are PM's USID Sales for a Sub Market?
Is there a way to do this without typing a long and confusing logical statement?
Thanks!
I am trying to determine total "Sales" based on various combinations of three drop down boxes.
For instance, What are PM's USID Sales for a Sub Market?
Is there a way to do this without typing a long and confusing logical statement?
Thanks!
Hi and welcome to the forum
See if this is what you are after?
=SUMIFS(Data!$D$2:$D$20,Data!$A$2:$A$20,'FCST Counts'!A5,Data!$B$2:$B$20,'FCST Counts'!A2,Data!$C$2:$C$20,'FCST Counts'!A8)
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
It does, thank you. But how would I show, for example, Microwave Sales for all Sub Markets and all PM's?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks