function results shows 0
Hi,
I have a weird problem using sum(if(...) function. the result shows 0 but
if I click on fx(next to the formula) to see the formula result, I see the
correct answer in the function Arguments window.
Here is my formula:
=SUM(IF('2006 Producteurs'!$B$2:$B$63="Arion",IF('2006
Producteurs'!$C$2:$C$63="Certifiée",'2006 Producteurs'!$E$2:$E$63,0),0))
I've tried to do it with only one condition and I get the same result....
bizzare!!! Any clue?
Merci!!!
--
Thanks, Line (pronounce LYNN)
|