I'm not sure what I need to do here, it may be a simple statement. But I need the sums in E3, F3, G3 to automatically update when the status in column H is answered with "deal lost". For example, A5 company is a lost deal, so I need E5 and F5 to be removed from the summed totals in E3 and F3 automatically based on the status of "deal lost". Column H is set up as a drop down menu, so there are only those three choices. I'm using Excel 2007.