Formula Question...

[SilverBullet]

I have a multi-column worksheet.

I want to total dollars by day.

Column "C" is the date. Column "K" is the dollars.

I don't want to have to manually sum each one. I have multiple months over multiple years.

Anyone know how?

 

[lenze]

PIVOT TABLE

 

[SilverBullet]

PIVOT TABLE

Can you be a bit more specific?? remember I'm a newbie

Thanks

 

[lenze]

Select a cell inside your table and then choose Data>Pivot Table Report. Follow the wizard, selecting the location for your table. When the grid is displayed, drag the Date field to the Row area and the Amount field to the Data Area.

See help file for Pivot Table examples

Book1
	A	B	C	D	E
1	DATE	AMOUNT
2	5/11/03	$5.00
3	5/12/03	$6.00		SumofAMOUNT
4	5/13/03	$7.00		DATE	Total
5	5/11/03	$8.00		5/11/03	19
6	5/12/03	$9.00		5/12/03	22
7	5/13/03	$5.00		5/13/03	20
8	5/11/03	$6.00		GrandTotal	61
9	5/12/03	$7.00
10	5/13/03	$8.00
11
Sheet1

 

[SilverBullet]

Wow that's great, going to try it out right now!!

Thank you SOO much