Formulas, Please help!!!
 

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!!!

Formulas, Please help!!!
 

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

Formulas, Please help!!!
 

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
--
Thanks for any help!!!


"Dave Peterson" wrote:

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