SUMIFS + Multi criteria + Date Range

[eyeope]

Hi All,

I'm trying to solve a problem that I have. I've attached the spreadsheet, in the tab "Closed Won Revenue per Week" - I'm trying to get ahold of the Revenue that falls between two dates, for a specific Country.

I've solved the Revenue between each date, but I can't add the countries.

Hope this makes sense.

Thanks,

Chris

Excel Forum_Help.xlsx

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Fotis1991]

Hello

Why don't you add 1 more criterion in your SUMIFS?

In B4 and copy down and across.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

See attached with the formula

Please Login or Register  to view this content.

in B4 needing copying across and down.

Incidentally your original formula was double counting the last day of the week since you had both the >= and the <= criteria.

I've also added a pivot table option and chart which you may find more useful and certainly a lot more flexible allowing you to see your data presented in various ways just by dragging and dropping fields around.

[eyeope]

Thanks!!

All solved now

[Oshawky]

hello

i think the first solution will be better by change the criteria you wand

=SUMIFS('Comm Rev Gantt'!$I$4:$I$34,'Comm Rev Gantt'!$J$4:$J$34, $A6,'Comm Rev Gantt'!$B$4:$B$34, ">="&B$1,'Comm Rev Gantt'!$B$4:$B$34, "<="&C$1)

[Richard Buttrey]

Thanks!!

All solved now

Don't forget the double counting of the last day of the week in adjacent weeks.