Looking for conditional averaging or "Averageifs" function for
I tried:
=SUMIF(G3:G73,"A",I3:I73)/COUNTIF(G3:G73,"A",I3:I73)
&
=AVERAGE(IF(G3:G73="A",I3:I73))
and neither worked? Did I completely do something wrong?
"Dave F" wrote:
You can use AVERAGE(IF(...)) entered as an array formula by hitting
CTRL+SHIFT+ENTER.
Alternativaley, you can do SUMIF(...)/COUNTIF(...) entered as a regular
formula.
Dave
--
Brevity is the soul of wit.
"threee11" wrote:
I have Office '02 at my workplace and am tryin to do some conditional
averaging (i.e. calculate averages of numbers in column C if same row in
column B is 'Bravo'), I know in '07 there is an averageifs function, any idea
of something similar for '02 or '03 (home computer)?
Thanks!
|