Question: Sum Data Across Multiple Columns / Rows

Good afternoon everyone,



I have attached a worksheet and Jpeg example of the issue I am having.

I am trying to SUM the data across a range of columns and rows dependant on 3 criteria. Week Number, Site & Type of Product (Meat, Fruit Veg in the example). Previously SUMIFS had been working but this was as I was doing the calculations by single rows.

I now have more data and need a robust way to SUM the data held across the area apply these 3 criteria.


Apologies if I haven't been very clear with this as I'm cautious now to mix terminology.


Many thanks,

Az

Hi,

Sumproduct is the way to go. See attached.

I feel incredibly silly at how easy you've made that :P

Thank you very much for the fast reply and simple solution!

Az