Look in the help index for SUMIF or give more detail.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MARY" wrote in message
...
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.

--
MARY