Hi

I am trying to use SUMPRODUCT to sum the values of a list by 2 conditions.
The list has a date column and a Category column and in my summary table i
would like to summarise all entries by date and column

Category is held in Summary!A3 and month is held in Summary!B1.

Can anyone point out where i am going wrong?

TIA

=SUMPRODUCT(Expenditure!$C$2:$C$100=Summary!A3)*MO NTH(Expenditure!$A$2:$A$100=MONTH(Summary!$B$1))