Excel 2007 : Sum if product name matches and date is between a range

Hi all,

I have a problem writing a formula and hope if you could help me please (if it is even possible?!).

I have a big list of products sold between dates and what I am wanting to create is a summary table on a new sheet. I need it to sum the number of specified products sold between two dates. Unfortunately this has to be done (if possible!) using a formula and not VBA. What I was thinking of is a sumifs formula and have:

If my product name is in column A1, date from is in B1 and date till is in C1, the formula I currently have is as follows:

=sumifs(itemssold,product,A1,Date,>=B1,Date,<=C1).

I assume it won't work because I am trying to do a formula to find between dates?
Could anyone help please? I am posting it in 2007 as I think the sumifs function is new and there may be some other new function I could use.

Many thanks, it would be fantastic if we could get this working.

SUMIFS will be fine you just need to create your criteria strings appropriately

Please Login or Register  to view this content.

[assumes all ranges share the same dimensions]