Mean Formula

[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.

 

[J.E. McGimpsey]

What does "a mean with multiple criteri(a)" mean to you?

 

[Jerry W. Lewis]

=AVERAGE(IF((critera1)*(criteria2)*(criteria3),data,""))

array entered (Ctrl-Shift-Enter).

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

Jerry

 

[Stephen Bye]

DAVERAGE

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.

creating financial statements