Conditional Summing?

[Rollin_Again]

I have a workbook that countains many records. Each of recor
represents each of our company's clients. To simply my question w
will assume that there are only three columns used: *Client Name
(Column A) , *Active Status* (Column B), and *Potential Savings
(Column C.) Column B will contain a value of either "YES" or "NO" t
determine whether or not the client is participating in a cos
reduction program. What I want to do is put a formula in cell D1 tha
will take the sum of all cells in Column C where there is an Activ
Status (Column B) value of "YES." The ultimate goal is to be able t
calculate the different total potential savings on the fly when makin
changes to the Active Status column. I hope what I said is clear. An
help will be greatly appreciated.


Rolli

 

[Rollin_Again]

OK....I figured it out. I didn't know there was a conditional su
wizard add-in for Excel


Rolli

 

[tghcogo]

Use the SUMIF function,

=SUMIF(B2:B15,"=yes",C2:C15)

make sure the ranges fit your data and hey presto

Cheers

TGHCOG

 

[Andy B]

Hi

Try this:
=SUMIF(B:B,"YES",C:C)

 

[Rollin_Again]

*Use the SUMIF function,

=SUMIF(B2:B15,"=yes",C2:C15)

TGHCOGO *

Thanks, your method works also and it's easier to translate your metho
into VBA

Rolli