I have a spreadsheet that contains multiple totals. I keep track of customer payments with this excel spreadsheet. Each Customer has their own total. I would like to compute a grand total by adding each customer's total. Can this be done? If I utilize the sum function, I have to click on each cell indivdually to add them which becomes very time consuming.
CUSTOMER1 NAME
Date Notes Total
5/15 Total owed $100.00
5/30 Paid Cash -$15.00
6/02 Paid Cash -$10.00
Total $75.00
CUSTOMER2 NAMEDate Notes Total
5/15 Total owed $200.00
5/30 Paid Cash -$15.00
6/02 Paid Cash -$10.00
Total $175.00
TOTAL OWED: $250.00 *** I want to add the total due for each customer.
Thanks in advance for the help!
CUSTOMER1 NAME
Date Notes Total
5/15 Total owed $100.00
5/30 Paid Cash -$15.00
6/02 Paid Cash -$10.00
Total $75.00
CUSTOMER2 NAMEDate Notes Total
5/15 Total owed $200.00
5/30 Paid Cash -$15.00
6/02 Paid Cash -$10.00
Total $175.00
TOTAL OWED: $250.00 *** I want to add the total due for each customer.
Thanks in advance for the help!