I'd put the subtotal formulas in row 1, the column headers in row 2 and the data
in rows 3-###.

Then I'd use formulas like:
=subtotal(9,E3:E65536)
In E1

Since it's using =subtotal(), it'll ignore any rows hidden when you apply the
data|filter|autofilter to rows 2:###

Debbie wrote:

OK... I hav a spreadsheet that has 10 Columns. Three of these columns are
money, The other columns are Names, Date, Check #, ect. Each Row is a
specific transaction or sale. What I would like to do is for the 3 Columns
that have money in them to keep subtotals of each column and a total of all 3
as data is being entered. I have been able to do this with a completed
spreadsheet but haven't figured out how to apply a formula that will
calculate as I go. I also need to be able to use my filters and print
receipts with the Subtotals and Total for that person. Can anyone please
help me with this, I would be extremely grateful!!
Example:

A B C D E F G
H I J
- Date Name Name Name $40.00 $10.00 CH# $125.00 X
- Date Name Name Name $40.00 $10.00 CH# $125.00 X

Subtotals $80.00 $20.00
$250.00
Total
$350.00

If it makes a difference I have Excel 2007

--
Thanks for any help!!!

--

Dave Peterson