Conditional Formatting

[darksnowman56]

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.

 

[Lewiy]

Not conditional formatting, you will want SUMIF() for this:

Excel Workbook
	A	B
1	25	yes
2	30	no
3	19	yes
4	40	no
5	34	yes
6	90	no
7	25	yes
8		103
Sheet2

 

[Jonmo1]

that's not conditional formatting. Conditional formatting changes the FORMAT of a cell based on it's value. It doesn't do any mathematical fomulations. What you want is a sumif formula.

=SUMIF(B1:B1000,"Yes",A1:A1000)

 

[texasalynn]

you asked about conditional formatting, but your message talks about summing. So I think you want the sumif function

 

[venkat1926]

if you want to total only those A values which has corresponding B value as "yes" and if your data is from A1 to B9 use this formula

=SUMPRODUCT(($B$1:$B$9="yes")*($A$1:$A$9))

modify the formula to suit you.

 

[darksnowman56]

awsome...thanks all!