Just curious, what do you want if $Z$58 is not blank and not an x?
=IF($Z$58="",SUM(AG46,AG48,AG50),IF($Z$58="x",0,"Z 58 is neither equal to x
or blank")
--
** John C **


"Louise" wrote:

I have a formula that is not working.
=if($Z$58="",ag46+ag48+ag50)-if($z$58="X",0) If cell z58 is empty I want it
to add the ag cells and if z58 cell has an x in it I want it to show 0. It
is doing 0 for both functions, it is not adding the ag cells. What am I
doing wrong?
--
Louise