Hi,
I am trying to use the averageif statement. I would like to average cells on seperate worksheets if they are not zero. I am not sure how to averageif using multiple worksheets. I thought the formula below would work but it does not...

=AVERAGEIF((Sheet1!F6,Sheet2!F6,Sheet3!F6),"<>"&0)

Any suggestions?

Thnx