• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • 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


  • 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


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.


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