Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average If Array Formula | Excel Worksheet Functions | |||
Average array | Excel Worksheet Functions | |||
Array average question | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Average Array Formula | Excel Worksheet Functions |