Adding values within date ranges

[ktf71096]

Hello,

New to this site - so sorry if this was covered already.

I have a spreadsheet that I'm working on - and I'm simply stumped on how to do something.

I have several part numbers that we've been selling. While I can easily determine the total of each part sold since the beginning, I can't figure out use excel to look at the part numbers within a certain time period & add up the total qty sold of each item during the last 12 months & 6 months. (Need to know to help in forecasting)

My spread sheet is laid out with the following

B Column - Job Number.
C Column - Client Part Number.
D Column - My part number.
E column - Description of part.
F Column - Qty Sold.
H Column - Ship date.

I'm trying to determine:
1. How many of each of the Client P/N#'s shipped in the last 12 months, and
the last 6 months.

2. How many of each part (with my Part numbers) shipped during the same
time period.

Any help would be highly appreciated!

Thanks,
Kyle

[oldchippy]

Take a look at this link it may help?

http://www.contextures.com/xlFunctions02.html

[starguy]

Hello,

New to this site - so sorry if this was covered already.

I have a spreadsheet that I'm working on - and I'm simply stumped on how to do something.

I have several part numbers that we've been selling. While I can easily determine the total of each part sold since the beginning, I can't figure out use excel to look at the part numbers within a certain time period & add up the total qty sold of each item during the last 12 months & 6 months. (Need to know to help in forecasting)

My spread sheet is laid out with the following

B Column - Job Number.
C Column - Client Part Number.
D Column - My part number.
E column - Description of part.
F Column - Qty Sold.
H Column - Ship date.

I'm trying to determine:
1. How many of each of the Client P/N#'s shipped in the last 12 months, and
the last 6 months.

2. How many of each part (with my Part numbers) shipped during the same
time period.

Any help would be highly appreciated!

Thanks,
Kyle

your first requirement

=SUMPRODUCT(((C1:C100="Part No")*(H1:H100<=TODAY())*(F1:F100)))
(use the correct part no. in formula instead of "Part No")

in your second question what do mean by same time period, month, day or year

[ktf71096]

Thanks guys for your quick responce!

As for starguys question the second part of my quesition is - I'm looking to find out how many of my part numbers sold in the last 12 months & six monts.