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
Bookmarks