excel, what if function referencing another cell
 

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

excel, what if function referencing another cell
 

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

excel, what if function referencing another cell
 

Mary,

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

Regards,
Paul

--

"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

excel, what if function referencing another cell
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PCLIVE" wrote in message
...
Mary,

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

Regards,
Paul

--

"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