Totals in Excel

[GasMan]

Hi,

I would like to create a sheet that has the following columns

date shop total VAT? NET Amt VAT Amt

I have worked out how to filter the data so that I could see all that
was spent on a particular date or at a particular shop suing the first
2 columns..

What I would like to see is the totals for all the rows, depending on
the filter in the first 2 columns being set, and have this running
total at the top of the sheet above the column labels, thereby seeing
how much in total was spent either on a particular day, or at a
particular shop, or a combination of both.

Is this possible?, and if so how please.

I am using Excel 97.

TIA
Please remove obvious from email address if emailing.

 

[JE McGimpsey]

Your best bet is probably a Pivot Table:


http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Terri]

Have you tried a pivot table to do this?

 

[GasMan]

I'll look into pivot table.

Thank you

Have you tried a pivot table to do this?

Please remove obvious from email address if emailing.

 

[GasMan]

I'll look into pivot table.

Thank you

Your best bet is probably a Pivot Table:


http://peltiertech.com/Excel/Pivots/pivotstart.htm

Please remove obvious from email address if emailing.