I have a question when using excel averageif functions:
I have a workbook containing monthly information (stored as numerical values) in 12 different worksheets (named Jan, Feb,..., Dec). In each worksheet, I calculate the sum, e.g. =SUM(B1:B100)
and store it in cell A1.
I create an overview worksheet which takes average of each month's A1 values, and I want to exclude those with 0.
I use the formula
=AVERAGEIF(Jan:Dec!A1, ">0")
however, I got #VALUE!
using this averageif function.
What is the cause of this problem? Can't the range of AVERAGEIF be the result from another SUM function?