G
Guest
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
$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