Summarising multiple entries in an Array - Help with SUMIFS

Hi all,

Im having a bit of trouble trying to summarise a large array of data. The array has entries for all our suppliers and the office that is responsible for that supplier. Each column then has a date and each row has an entry for that date depending on the expected cost for that day.

I would like to summarise the whole array by showing how much each office is due to spend on each of the days.

A small example is attached. The top sample is the array, the 2nd table is my failure to use SUMIFs and the bottom table is where i want to get (manually filled in). I thought SUMIFS would be the way to go but i think im missing something.



Any help would be appreciated, thanks in advance

J

Hi check attachment