Sumif for part number across date range.

[chaysp81]

Hi I am looking to count a part number across a date range. I am not to sure what to use, I can do the quantity by date but I don't know how to add a part number in there.

I need Total number of parts sold by part number between a date period.

attached is the raw export I get.

thank you for any help in advance.

[DonkeyOte]

See SUMIFS [and/or COUNTIFS] function (available from XL2007 onwards)

If the date range is say monthly you could also consider use of a Pivot Table.

[Marcol]

Given you only need to use versions of Excel 2007 and later, you could use SUMIFS()
e.g.
In your sample

Please Login or Register  to view this content.

This will give you the total parts sold between, but not including, 15-Jan-10 and 05-Feb-10
.
i.e.
29-Jan-10

Hope this helps

[chaysp81]

With a bit of tweaking i have got this working perfectly. i have added a date range and asked it to search between these dates

=SUMIFS('12 MONTH USAGE'!F:F,'12 MONTH USAGE'!K:K,A239,'12 MONTH USAGE'!E:E,">="&$AB$1,'12 MONTH USAGE'!E:E,"<="&$AB$2)

thank you for your help on this. It has helped me incredibly