Mean Formula

  • Thread starter Thread starter skweetis
  • Start date Start date
S

skweetis

Does anyone have any suggestions on calculating a mean with multiple
criterion. There isn't a native function in Excel that I am aware of,
but would like to get any ideas on something i could do.
 
=AVERAGE(IF((critera1)*(criteria2)*(criteria3),data,""))

array entered (Ctrl-Shift-Enter).

In this formula * is equivalent to AND (change to + for OR)

Jerry
 
DAVERAGE

skweetis said:
Does anyone have any suggestions on calculating a mean with multiple
criterion. There isn't a native function in Excel that I am aware of,
but would like to get any ideas on something i could do.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top