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)

"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)


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)

=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)

"deroline" wrote in message
...
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)

MERCI BEAUCOUP!!! It works now... I did'nt know about that!!!!!
--
Thanks, Line


"deroline" wrote:

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)