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

=SUMPRODUCT((E1:E100="Michelle Fuerth")*C1:D100)

"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

On Nov 7, 10:40 am, 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

Check out the "Sumif" function, this should work.
=sumif(E1:E1000,"Michelle Fuerth",C1:C1000)+sumif(E1:E1000,"Michelle
Fuerth",D1:D1000)

hth

Carlo

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