I have a spreadsheet where a colum has the same drop down in every box with 2 choices eg new business & existing business. in the adjacent column there is a monetary value of that business. on a seperate sheet i need to be able to show the sum total of new business and existing busness. how do i seperate the 2 types of revenue out?

Dan