AVERAGE formula not working

[Julz]

Good day,

What am I doing wrong?

=AVERAGE(monthopen!$U$4:$U$20014=1,monthopen!$G$4:$G$20014)/(monthopen!$U$4:$U$20014=1)



Is there an online source for advanced Excel formulas?

Thanx,
~Julz

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER)
=AVERAGE(IF(monthopen!$U$4:$U$20014=1,monthopen!$G$4:$G$20014))

or
=SUMIF(monthopen!$U$4:$U$20014,1,monthopen!$G$4:$G$20014)/COUNTIF(month
open!$U$4:$U$20014,1)

As an online ressource for advanced formulas: you're alread there

 

[Julz]

You're right. You're ALWAYS right!

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER)
=AVERAGE(IF(monthopen!$U$4:$U$20014=1,monthopen!$G$4:$G$20014))

or
=SUMIF(monthopen!$U$4:$U$20014,1,monthopen!$G$4:$G$20014)/COUNTIF(month
open!$U$4:$U$20014,1)

As an online ressource for advanced formulas: you're alread there