Formulas, Please help!!!

D

Debbie

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
 
D

Dave Peterson

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:###
 
D

Debbie

Thanks Dave!! I really appreciate your help. That works very well for what
I'm trying to do. Sorry it took me so long to reply, I've been out of town
and didn't check mail, my bad!! Thank you again.
Debbie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top