View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
noreaster noreaster is offline
external usenet poster
 
Posts: 16
Default Getting the Sum from months

I have 3 columns A-part numbers, B-Date (year, month, date) and C-quantity.
What I'm trying to figure out is how to get a Qty for Part for a month for
each month and do the same for each part. The sum would go to a cell.
ie
Part Date Qty
123 08 10/10 15
124 08 10/10 10
123 08 10/11 20


Some parts may repeatd in the same month. I have figured out how to get the
total quantity but trying to break in it down in months has me somewhat
stumped.

TIA