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.