Multiple Search and SUMIF

[jj123]

Hi - I have a spreadsheet (attached) in which I am trying to find the total values in each month, from a yearly total based on three sumif functions - in the sheet these are person, place and category.

I am trying to find a way of searching this criteria and returning the relevant totals per month (a simple pro rata'd across the 12 months is fine)

At the moment I have several sumif formula's but I believe the answer lies in a sumproduct of some variety.

Any help would be very much appreciated.

Thank you!!!

[Fotis1991]

Hi

In G7 and copy down and across.

=SUMPRODUCT((B!$D$6:$D$26=A!$B7)*(B!$B$6:$B$26=A!$C7)*(B!$C$6:$C$26=A!$D7)*(B!F$6:F$26))

This will gives you the numbers per year.

We can not do this by month because we don't know the months...

[jj123]

Thank you for your response - I have attached a slightly more realistic example with an intro into the sumif that I am using.

Wondering if there is a more efficient way than just doing several IF Functions by year.

THANKS!!!