View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default calculating the sum of different categories over a given time peri

What program are you using that has an infinite number of rows?

--

Cheers,
Shane Devenshire


"JeffK" wrote:

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