Average Array
 

Hello,

Would like to calculate an average on an array based on a condition.

For example, if I do:

= SUM((Color="Red")*(Units))

I get the sum of all the units which are red....my arrays are Color
and Units

However, if I try:

= AVERAGE((Color="Red")*(Units))

I get a different answer than I would expect. It looks like this
formula sums up my units in red, but then counts the total number of
units to calculate the average.

Any suggestions?

Average Array
 

Tex,

You're averaging a lot of Zero values.

Array enter - enter using Ctrl-Shift-Enter

=AVERAGE(IF(Color="Red",Units))

HTH,
Bernie
MS Excel MVP


"Native" wrote in message
...
Hello,

Would like to calculate an average on an array based on a condition.

For example, if I do:

= SUM((Color="Red")*(Units))

I get the sum of all the units which are red....my arrays are Color
and Units

However, if I try:

= AVERAGE((Color="Red")*(Units))

I get a different answer than I would expect. It looks like this
formula sums up my units in red, but then counts the total number of
units to calculate the average.

Any suggestions?