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) |
function results shows 0
"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) |
function results shows 0
=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) |
function results shows 0
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) |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com