Hi,

I am trying to use a COUNTIF function across multiple sheets and for some reason i cant get it to work.

I am trying to sum "nonzero" values across multiple sheets. For example:

Average all non-zero values from cells
Sheet1!A2
Sheet2!A2
Sheet3!A2
Sheet4!A2