function results shows 0

D

deroline

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

Teethless mama

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

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