hoping assistance on averageif type of function please.
my workbook has following worksheets: a, summary, b, b summary, c, c summary, etc.
i'm looking average range k16:t16 summary worksheets.
the criteria average ignore "zero" values.
would there formula assist in this?
in simplified world, formula i'd looking @ =averageif('* summary'!k16:t16,">0")...?
many in advance.
in row2 columna enter:
="'"&char(row()+63)&" summary'!k16:t16" in row2 columnb enter:
=sumif(indirect(a2),">0") in row 2 columnc enter:
=countif(indirect(a2),">0") copy above 3 formulae down suit (but not far see #ref!).
in b1 enter:
=sum(b2:b100000) and copy across c1.
in a1 (the result, hopefully!) enter:
=b1/c1 
Comments
Post a Comment