J
JimG
I have an AVERAGE IF formula that works fine on a single worksheet for July
1st...
=AVERAGEIF('7-1'!N:N,">0",'7-1'!N:N)
I need it to work across 31 worksheets, so it will accurately calculate the
averages for all values greater than zero, and for the entire month.
Any ideas?
1st...
=AVERAGEIF('7-1'!N:N,">0",'7-1'!N:N)
I need it to work across 31 worksheets, so it will accurately calculate the
averages for all values greater than zero, and for the entire month.
Any ideas?