Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help please
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 |