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