Average

  • Thread starter Thread starter Powlaz
  • Start date Start date
P

Powlaz

I am using the following formula in rows 1-54 in Column G

If (E2:E54>0,AVerage(If(f2:f54>0,f2:f54,"")),"")

Problem is if the data in row 1 isn't filled in before
any one of the other rows, the formula doesn't
calculate. How can I rewrite the formula to calculate
regardless of which row has complete data first?

Thanks,

matt
 
=SUMPRODUCT(--(E3:E54>0),--(F3:F54>0),F3:F54)/SUMPRODUCT(--(E3:E54>0),--(F3:
F54>0))

or

=AVERAGE(IF((F2:F54>0)*(E2:E54>0),F2:F54,""))

the latter entered with ctrl + shift & enter
 
Thanks for the help guys. I understand Frank's solution
but I'm going to play with Peo's because I've never used
sumproduct and I'm curious.
Thanks again,

Matt
 
Back
Top