Summing Between Two Dates for multiple criteria

[Jbrous]

I have recently built a database for my company's sales. I have three columns: Date, Item, and Sales. What I want to do is sum the sales between dates for any combination of items. I have a formula that currently works for 1 item, but when I try to add in a second item the formula returns a "!VALUE".

Any help would be greatly appreciated.

[Ace_XL]

Perhaps use

=SUMIFS(C:C,B:B,"item",A:A,">="&Lowerdate,A:A,"<"&Higherdate)

[Jbrous]

Yes, that works for summing the sales for one item. How do I add in a second item in that formula? Say for example "the combined sales of product X and product Y or a given time period".

[FDibbins]

try =SUMIFS(C:C,B:B,or("itemA"m"itemB"),A:A,">="&Lowerdate,A:A,"<"&Higherdate)
or
SUMIFS(C:C,B:B,"itemA",A:A,">="&Lowerdate,A:A,"<"&Higherdate)+SUMIFS(C:C,B:B,"itemB",A:A,">="&Lowerdate,A:A,"<"&Higherdate)