Posted by Joann B. on August 15, 2001 7:01 AM
I have a spreadsheet with multiple columns of data which represents the costs for different types of shipping errors. One of the columns is the date on which the error occurred, another is the cost for the error and the rest are broken down by the different types of errors. Right now I am charting the dollars lost for the different types of errors, and I would like to create a chart with a trend line for total dollars lost each month.
I would like to know if there is a formula that would seek out and tally the cost of the errors during a given month, even though the dates are not necessarily entered on the spreadsheet in chronological order (ie. a June date might be after a July date).
Thanks for your help.