M
martinezr4
I am looking to do an AverageIf across multiple sheets but only if the
value is greater than 0. Now when I do a standard average it works
fine except it counts the cells with zero's against the overall
average which would be resolved if the averageif command worked.
Here is the command:
=AVERAGEIF(Start:End!H3,">0")
I have created a start and end sheet in the workbook so that it can
capture all sheets in-between but I cannot get this to work. Any
assistance would be appreciated!
value is greater than 0. Now when I do a standard average it works
fine except it counts the cells with zero's against the overall
average which would be resolved if the averageif command worked.
Here is the command:
=AVERAGEIF(Start:End!H3,">0")
I have created a start and end sheet in the workbook so that it can
capture all sheets in-between but I cannot get this to work. Any
assistance would be appreciated!