• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Apportioning sales based on Division and Status to the current sales by store

M

melvin

Member
Gday all,

I use a combination of sumifs and sumproduct to apportion sales to stores, however I do one division and one status at a time.

Is there a way where I can do sumifs and sumproducts all together to get the final result.

Regards,

Melv.
 
X11: =W11+INDEX($U$3:$V$6,MATCH($V11,$T$3:$T$6,0),MATCH($U11,$U$2:$V$2,0))*$W11/(SUMPRODUCT(($U$11:$U$24=$U11)*($V$11:$V$24=$V11)*($W$11:$W$24)))

Copy down
 
That was my first step. However wasn't getting the output. Appreciate your time mate.

Have a great day
Melv.
 
You must log in or register to reply here.
Back
Top