darksnowman56
New Member
- Joined
- Jun 22, 2007
- Messages
- 32
column A has dollar amounts, column B has a yes/no list, and a total at the bottom of column A. im assuming conditional formatting will help me with what im looking to do, but im having a little trouble with the formula. What i need is a formula that says if column B has a yes then the number next to the yes (in column A) will be totaled up. So only numbers next to the yes will be totaled in the total box at the bottom of column A.