Sum if based on 2 criteria

[SalamanderSam14]

I have a table that i trying to do accounts on.

Currently i have a date colum A, a value in column D, a catagory in column E.

What i want to achive is a total for each item if the date is within the same month and in the same catagory. Kind of hard to explain.

I have posted a blank excel with the headers and just below ive shown what i would like to achieve (however ive not used formulas). Hiope this helps explain a little more

I have coloured the feild yellow which im looking for a formula for

Thanks for any suggestions

[Fotis1991]

No attachement but looks like to need SUMIFS function.

[TheExcelphile]

Hi Sam,

Looks like your file didn't get posted. Can't see it anywhere!

[SalamanderSam14]

it would help if i attatched the item :s

[Fotis1991]

Do you mean?

=SUMPRODUCT((MONTH($A$6:$A$12)=MONTH(A6))*($E$6:$E$12=E6)*($D$6:$D$12))

In G6 and copy down.

[SalamanderSam14]

Thats brilliant thanks, Just to improve upon that formula is there any way of making it a rolling total for the catagorys?

[Fotis1991]

...s there any way of making it a rolling total for the catagorys?

can you explain a little more your request?