Formula explanation

[nedy_03]

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]

It is exactly the same as

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

[nedy_03]

Thx ... xld! Always on time.

[nedy_03]

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]

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]

i deleted the "\" from the formula and it returns the same result! .... .. thx for all!

[Bob Phillips]

If you deleted the \, you then don't need =7, 7 is sufficient.