S
stebro
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
- 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