SUMIFS multiple criteria

[jcm900]

Hi, I have two SUMIF formulas

columns G, and F in sheet "Order details" are numbers and so is value in D2 but Column F in "Orders" contains dates.

The following formulas work by themselves but I need to combine them.

=SUMIF('Order Details'!F:F,D2,'Order Details'!G:G)


=SUMIF(Orders!F:F,">"&TODAY(),'Order Details'!G:G)

I have tried to combine them ( see below) with SUMIFS but an error is returned - it doesnt seem to like the date part.

=SUMIFS('Order Details'!G:G,'Order Details'!F:F,B2,Orders!F:F,">"&TODAY())

Many thanks

Phil

 

[jcm900]

Just to clarify this is the formula combined that isn't working with D2 substituted for B2 as it should be.

=SUMIFS('Order Details'!G:G,'Order Details'!F:F,D2,Orders!F:F,">"&TODAY())

Thanks

Phil

 

[Fluff]

That formula works for me, in what way doesn't it work for you?