Value separation and then adding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Walt Moeller - 04 Mar 2008 16:50 GMT

Here is what I would like to do:

If any cell in this list k10,k36 = "R-C" the take the corresponding cell in
e10,e36 and add as a total in e37

Signature

Walt Moeller

Reply to this Message

Ron Coderre - 04 Mar 2008 16:55 GMT

Try this:

E37: =SUMIF(K10:k36,"R-C",E10:E36 )

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> Here is what I would like to do:
>
> If any cell in this list k10,k36 = "R-C" the take the corresponding cell
> in
> e10,e36 and add as a total in e37

Reply to this Message

PCLIVE - 04 Mar 2008 16:59 GMT

Try this:

=SUMIF(K10:K36,"R-C",E10:E36)

HTH,
Paul

> Here is what I would like to do:
>
> If any cell in this list k10,k36 = "R-C" the take the corresponding cell
> in
> e10,e36 and add as a total in e37

Reply to this Message