Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Excel's Fourier Analysis should be a function, so that results upd | Excel Worksheet Functions | |||
Omit blank cells from function results | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Using function results as parameters in another function | Excel Worksheet Functions |