Average

[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

 

[Frank Kabel]

Hi Matt
try
If (COUNT(E2:E54)>0,AVerage(If(f2:f54>0,f2:f54,"")),"")
Frank

 

[Peo Sjoblom]

=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

 

[Powlaz]

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

 

[Ken Wright]

=AVERAGE(IF(E2:E54,F2:F54))

array entered.