Thread: Excel 2003 Formula

Using excel 2003, how would I calculate the total cost, sorting by a person’s name and then by a date range from sheet1.
I want it to search column A by a certain person and then add column p if it falls within the B2-C2 range from sheet2.
This is the formula I was using, but now I need to include the date range on sheet1. SUMIF(Sheet1!$A$3:A345,"Paul Jones",Sheet2!P3:P345)

Sheet 1 (master table)
Column A = List of Names
Column K = Dates Sold
Column P = Total Cost

Sheet2 (report)
B2 = Start Date (1/1/2010)
C2 = End Date (1/31/2011)

Trying to get the total cost per year by a certain individual.

Formulas can do the trick, but have you considered pivot tables? Much more flexible. If you absolutely require formulas, attach a sample book and I'll work it for you.

Welcome to the forum, Buzz.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.