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! |
All times are GMT +1. The time now is 01:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com