=If(LEN... formula

[apurk45]

Here is the formula I'm trying to use:

=IF((LEN(S4:S6)=0,""),(LEN(S4:S6)>0,AVERAGE(S4:S6)))

Unfortunately, I am getting error message " There is a problem with this formula". Do you see anything that I need to change?

Your advise will be greatly appreciated

 

[jimrward]

What version of excel are you using

 

[apurk45]

Excel 2016

 

[jtakw]

Hi,

Since you're trying to AVERAGE S4:S6, I assume you're dealing with numbers, try this:

=IF(COUNT(S4:S6),AVERAGE(S4:S6),"")

 

[jimrward]

Try =AVERAGEIF(S4:S6,”<>0”)

 

[Scott Huish]

I think this is what you are trying to achieve:

=IF(COUNT(S4:S6)=0,"",AVERAGE(S4:S6))