Simplify IF statement

[cch70]

Trying to get the average of 3 cells (D41,F41,H41)with formulas in each based on the following conditions:

("blank" is not really blank but the formula in each cell is set up to return blank upon certain conditions)

• If D41,F41 AND H41 are all three blank, leave blank
• IF D41,F41 are blank, give me H41
• If H41, F41 are blank, give me D41
• If D41, H41 are blank, give me F41
• If D41 is blank, give me (F41+H41)/2
• If F41 is blank, give me (D41+H41)/2
• If H41 is blank, give me (D41+F41)/2
• If not, give me (D41+F41+H41)/3

This is what I had done so far:

=IF(AND(ISERROR(VALUE($D$41)),ISERROR(VALUE($F$41)),ISERROR(VALUE($H$41))),"",IF(AND(ISERROR(VALUE($F41)),ISERROR(VALUE($H41))),$D41,IF(AND(ISERROR(VALUE($D41)),ISERROR(VALUE($F41))),$H41,IF(ISERROR(VALUE($D$41)),SUM($F$41,$H$41)/2,IF(ISERROR(VALUE($F$41)),SUM($D$41,$H$41)/2,IF(ISERROR(VALUE($H$41)),SUM($D$41,$F$41)/2,SUM($D$41,$F$41,$H$41)/3))))))

I need to simplify to "squeeze" one more IF statement.
Thanks for your help!

[shg]

Maybe =IF(COUNT(D41,F41,H41)=0, "", AVERAGE(D41,F41,H41))

[cch70]

lol!!!
Thanks a million.