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

calculating the sum of different categories over a given time peri
 

Suggest that the time period be defined clearly as a particular "month-year",
for eg: Dec08
rather than just the month

Assuming col B contains real dates
you could use something like this:
=SUMPRODUCT((TEXT(B2:B1000,"mmmyy")="Dec08")*(A2:A 1000="Product A"),C2:C1000)

Adapt the ranges to suit the smallest max data extent
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"JeffK" wrote:
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.

calculating the sum of different categories over a given time
 

Thanks Max, worked great

Cheers, happy newyear

"Max" wrote:

Suggest that the time period be defined clearly as a particular "month-year",
for eg: Dec08
rather than just the month

Assuming col B contains real dates
you could use something like this:
=SUMPRODUCT((TEXT(B2:B1000,"mmmyy")="Dec08")*(A2:A 1000="Product A"),C2:C1000)

Adapt the ranges to suit the smallest max data extent
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"JeffK" wrote:
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.

calculating the sum of different categories over a given time
 

Welcome, Jeff
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"JeffK" wrote in message
...
Thanks Max, worked great
Cheers, happy new year

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