What are the {'s either side of my if statement?
 

when I edit the cell they disappear and my formula display #value!

eg:

{=IF(SUM(IF(Tracking!$G$17:$G$9895="NB",
IF(Tracking!$P$17:$P$9895="X",1,0),0))0,
SUM(IF(Tracking!$G$17:$G$9895="NB",
IF(Tracking!$P$17:$P$9895="X",1,0),0)),"")}

This means that you have an array formula, that is it is using what are
typically single cell functions against an array of cells.

The { } are just a way of showing in the formula bar that it is an array
formula.

An array formula is committed using Ctrl-Shift-Enter, not just Enter. You
will then see the braces in the formula bar. If you just Enter, you will not
see the braces and the formula will not work.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"robagiles72" wrote in message
...
when I edit the cell they disappear and my formula display #value!

eg:

{=IF(SUM(IF(Tracking!$G$17:$G$9895="NB",
IF(Tracking!$P$17:$P$9895="X",1,0),0))0,
SUM(IF(Tracking!$G$17:$G$9895="NB",
IF(Tracking!$P$17:$P$9895="X",1,0),0)),"")}