function results shows 0

[Guest]

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!!!

 

[Guest]

"deroline" wrote:
=SUM(IF('2006 Producteurs'!$B$2:$B$63="Arion",IF('2006
Producteurs'!$C$2:$C$63="Certifiée",'2006 Producteurs'!$E$2:$E$63)))

ctrl > shift > enter (not just enter)

 

[Bob Phillips]

=SUMPRODUCT(--('2006 Producteurs'!$B$2:$B$63="Arion")
--('2006 Producteurs'!$C$2:$C$63="Certifiée"),
'2006 Producteurs'!$E$2:$E$63)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

MERCI BEAUCOUP!!! It works now... I did'nt know about that!!!!!