Excel AverageIF issue... PLEASE HELP!
 

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!

Excel AverageIF issue... PLEASE HELP!
 

You can use an averageIf array if you have an array. So lets cheat and make
one:

In I1 thru I3 in any sheet enter:
=Sheet1!H3
=Sheet2!H3
=Sheet3!H3
and so on downward and then:

=AVERAGE(IF(I1:I30,I1:I3))

enter as an array formula with CNTRL-SHFT-ENTER rather than just ENTER

--
Gary''s Student - gsnu200756


" wrote:

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!