Average

[Dundee Lad]

Can any one help me with the formula below. I found this using search but cant seem to get it to work!

=sum('December Measures'!E18+'January Measures'!E18+'March Measures'!E18+'February Measures'!E18)/countif('December Measures'!E18,'January Measures'!E18,'February Measures'!E18,'March Measures'!e18,">0")

 

[Aladin Akyurek]

Insert two new sheets, name them First and Last, place all target sheets in between these two, and use:

=SUM(First:Last!E18)/MAX(1,COUNTIF.3D(First:Last!E10,">0"))

if you download and install the morefunc.xll add-in.

 

[Dundee Lad]

Thanks Aladin I will give this a try