View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JeffK JeffK is offline
external usenet poster
 
Posts: 53
Default calculating the sum of different categories over a given time peri

Hi,

I have a spreadsheet that consists of 3 columns and infinite rows. Column A
= Product type (A,B or C), Column B = Date (ddmmmyy), Column C = $ amount. I
used SUMIF to calculate the total $ sold of Product A but I want to now
stipulate a time frame (eg month of December). The data will continue to be
added to, so I want the total to adjust as new entries are added.

Can someone help me with this one

Thanks
Jeff