calculating the sum of different categories over a given time peri

J

JeffK

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
 
M

Max

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:A1000="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
 
J

JeffK

Thanks Max, worked great

Cheers, happy newyear

Max said:
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:A1000="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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Elapsed Time Over a Set Period 2
Adding up Cells Given a Condition 4
Sum Product Problem 4
Sumif as a fuction of If using multiple criteria 2
How do I get the sum of vlookup? 3
SUM determined by drop-down list 9
Calculating/displaying elapsed time TOTALS 3
Calculating the Count of Monthly Gains/Losses 3

Top