Sum (SUMPRODUCT), with various criteria. (dates)

Hi.

I'm having trouble adding (SUMPRODUCT), with various criteria.

using a comparison with dates.

Hi,

With 2007 you'd be better advised to use the SUMIFS() formula (that's SUMIFS plural).
You should also arrange your data so that you use proper date numbers on your results sheet rather than just month names with a year on row 3.

Better still though, do away with the Results sheet and use a Pivot Table on your first sheet which will give you all the analysis and totalling you will ever need - and more.

but I have a tab in a date (dd / mm / yyyy) and another line the month 01

result in the guide, so January is the month (the full name of the month)

as sumifs, will accept this?

Yes it will.

In sheet2, B5, use this, copied down and across...

Please Login or Register  to view this content.

Just a tip for the future...if you are going to use dates, then use dates everywhere, dont use dates in 1 table, and then in another, use text (Jan, feb etc). That just creates all sorts of headaches trying to convert text (JANEIRO) to 1/1/2013
just to that small conversion, I had to use...
DATE(Result!$B$3,MONTH(365/12*(ROW(A5)-4)),1)

Hi.

Very good!!

Thank you!!

happy to help and thanks for the feedback