View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
deroline deroline is offline
external usenet poster
 
Posts: 2
Default 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)