If you use a pivot table to do this, the only additional step is to
refresh it after data entry. You can use a GETPIVOTDATA() function to
get the information anywhere in your workbook (in case you put the
pivot table on a different sheet), and you have the added bonus of a
convenient pivot report for easy formatting and presentation.

But, the trick is to remember to refresh the pivot table.


On Nov 6, 8:40 pm, cdw wrote:
Column C Column D Column E
$42,368.96 Jack Smith
$153,550.00 Michelle Fuerth

Above, I have the total sales in Column C and D, with each sales person
beside in Column E. I want a formlua that will total all the sales dollars
for Michelle Fuerth into ONE CELL at the bottom of my spreadsheet (like
below). Each time I enter Michelle's name in Column E above, I want it to
automatically add that sum of dollars from C or D (same row) to her total
below.

Michelle Fuerth Total Sales $153,550.00
Jack Smith Total Sales $ 43,368.96