SUM IF between two dates and another criterion

[CaityA]

Hey,

So I'm trying to pull combined sales data of an item between certain dates. The sheet I'm pulling from has the data by day so I'd need it combined for the specific dates queried using the item number.

Currently I was trying =SUMIFS(MIS!G:G,MIS!D:D,">="&DATE('PV Database'!O:O),MIS!D:D"<="&DATE('PV Database'!P:P),[[Item Number]]=MIS!A:A) but it doesn't seem to work...

The "at" from [item number] was removed due to the site thinking it was a link.

"MIS G" contains sales by day
"MIS D" contains the date by day
"PV Database O" contains start date
"PV Database P" contains end date
"MIS A" contains the item number

Apologies I can't share the document! Hopefully what I've noted here makes sense to someone...

Thanks

 

[JonXL]

Why are you using the DATE function?

 

[CaityA]

Ah sorry - I was playing earlier with the formula and didn't change it back before pasting.

Currently I'm at this point.. =SUMIFS(MIS[[#Headers],[Sales units/kg]],MIS[[#Headers],[Product (case)]],PVDB[[#Headers],[Item Number]],[[MIS[[#Headers],[Day]],">="&[@[Start Date ]], [MIS[[#Headers],[Day]], "<="&[@[End Date ]])

So that's meant to say.... Sum of tje sales if the product number matches the item number and if the day of sale in question is between the start and end date specified.