excel, what if function referencing another cell

[MARY]

I am looking how to do the following:

if there is a "no" in a cell, then I want the cell to the immediate left of
the "no" cell to add.

 

[Don Guillett]

Look in the help index for SUMIF or give more detail.

 

[PCLIVE]

Mary,

Did the response in your previous post not work? If not, please give more
details.

Regards,
Paul

 

[Don Guillett]

I agree. It is considered to be very rude to do what you have done here.