One method...............
Assuming your current data is in columns A and B
In C1:E1 enter February through April
In C2 enter =SUMIF(A1:A6,"February",B1:B6)
Same for D2, E2 and change the month.
Gord Dibben MS Excel MVP
On Thu, 10 May 2007 10:29:01 -0700, Nora Gaitan <Nora
wrote:
How do I set up an excel spreadsheet to do monthly recalculations in excel
2000?
For example:
February $2.00
February $3.00
March $1.50
March $1.50
April $1.00
April $1.00
Then set up a report that shows all of February totals?
Feb Mar Apr
$5.00 $3.00 $2.00, etc.