PDA

View Full Version : Formula explanation



nedy_03
08-16-2007, 10:13 AM
Does anybody have the patience to explain me what this function do, step by step ?? ..

=SUM(IF($I$5:$AM$5<6,IF(ISNUMBER($I8:$AM8),IF($I8:$AM8>$F8,$I8:$AM8-$F8,0),0),0))

Is a CSE formula, but the structure I know is somethins like :
=sum(if((condition)*(condition)*.....,range))

thx,
Alex

Bob Phillips
08-16-2007, 10:17 AM
It is exactly the same as

=SUM(IF(($I$5:$AM$5<6)*(ISNUMBER($I8:$AM8))*($I8:$AM8>$F8),$I8:$AM8-$F8))

nedy_03
08-16-2007, 10:44 AM
Thx ... xld! Always on time.

nedy_03
08-16-2007, 10:47 AM
could u help me om this formula too ?

=COUNTIF($I8:$AM8,"=7\")

what that "\" does ? ... the whole formula would be :

=SUMIF($I$5:$AM$5,"<6",$I8:$AM8)+COUNTIF($I8:$AM8,"=7\")*7-$AQ8

Bob Phillips
08-16-2007, 11:04 AM
Sure it is not =7?, where ? is a singleton wildcard. The other makes no sense. Actually =7? makes no sense either as row 8 is a number range.

Can you post the workbook with these formulae.

nedy_03
08-16-2007, 11:14 AM
i deleted the "\" from the formula and it returns the same result! .... .. thx for all!

Bob Phillips
08-16-2007, 11:18 AM
If you deleted the \, you then don't need =7, 7 is sufficient.