How do I write this OR Statement

[Galena1]

for averaging?

=AVERAGE(IF(X7 or T7 or P7 or L7 or H7 ORD7 >0, X7+T7+P7+L7+H7+D7))

thanks in advane for any help!

 

[Juan Pablo González]

You want the average of those cells if any of them is greater than 0?

 

[T. Valko]

for averaging?

=AVERAGE(IF(X7 or T7 or P7 or L7 or H7 ORD7 >0, X7+T7+P7+L7+H7+D7))

thanks in advane for any help!

Will there be any negative numbers?

 

[lenze]

=AVERAGE(IF((D7:X7>0)*(MOD(COLUMN(D7:X7),4)=0),D7:X7))

Entered using CTRL+SHIFT+ENTER

lenze

 

[T. Valko]

Will there be any negative numbers?

Ok, let's assume the numbers will always be positive.

=SUM(D7,H7,L7,P7,T7,X7)/INDEX(FREQUENCY((D7,H7,L7,P7,T7,X7),0),2)

 

[Galena1]

=if(sum(F19,J19,N19,R19,V19,Z19),0,0,SUM(F19,J19,N19,R19,V19,Z19)/INDEX(FREQUENCY((F19,J19,N19,R19,V19,Z19),0),2)

I tried to modify it to take care of #DIV/0! but it's not working

anyone know what is wrong with my syntax?

tanks!

 

[T. Valko]

=if(sum(F19,J19,N19,R19,V19,Z19),0,0,SUM(F19,J19,N19,R19,V19,Z19)/INDEX(FREQUENCY((F19,J19,N19,R19,V19,Z19),0),2)

I tried to modify it to take care of #DIV/0! but it's not working

anyone know what is wrong with my syntax?

tanks!

What version of Excel are you using?

What result do you want to replace the #DIV/0! error?