combo formula help required!

[moe1986]

hi, please find attached a formula i am having problems with.

i have a data tab which lists some spend by specific date.

i need a formula to summarize the total costs by month and year in the summary tab.

i've been trying to put a combo sumif/and/month/year but going up my own proverbial so coming to the forum for help!

[Fluff13]

Try
=SUMIFS(data!$F$5:$F$377,data!$C$5:$C$377,MONTH(C2),data!$D$5:$D$377,YEAR(C2))
copied across

[FlameRetired]

And another way.

Please Login or Register  to view this content.

[AlKey]

A shorter one

Please Login or Register  to view this content.

[Fluff13]

@AlKey
Unless I'm missing something couldn't your formula be shortened yet further to

Please Login or Register  to view this content.

Which relies on all the dates being the 1st of the month.

[moe1986]

Try
=SUMIFS(data!$F$5:$F$377,data!$C$5:$C$377,MONTH(C2),data!$D$5:$D$377,YEAR(C2))
copied across

perfect, thank you

[Fluff13]

You're welcome & thanks for the feedback.