What are you trying to do? Explain.
--
Don Guillett
SalesAid Software

"stebro" wrote in message
...
I've seen this many times but now I'm really desperate. Here's the
formula
- not that it matters I think - I'm hoping there is a principle that
applies
regardless of the funtion.
=SUM(IF(G3:G22="DUP",1,IF(G3:G22="NE",1,0)))

In the helper window I see the formula correctly identifies one condition
where the range contains "DUP" and 3 cases where it finds "NE" and shows a
result of 4.

However the value that displays as a result of this formula is zero. How
can I get the right answer to appear in the cell ????

Thanks,
sb