Whats wrong with this function?

[Angelsnecropolis]

B45 =IF(AVERAGE(B3434>0), AVERAGE(B3434),"")

It works fine when there is a number in B34 but if B34 is blank, even though
C34 and D34 are not blank, B45 is still blank.

How can I fix this so a number in any of the 3 fields will produce a number
in B45?

Thanks ^_^

 

[Rick Rothstein]

Give this a try...

=IF(COUNTA(B3434)>0, AVERAGE(B3434),"")

 

[Bob Phillips]

I think that you mean

=IF(COUNT(B3434)>0, AVERAGE(B3434),"")

or even

=IF(COUNT(B3434), AVERAGE(B3434),"")

 

[Angelsnecropolis]

Thanks for the help!

Give this a try...

=IF(COUNTA(B3434)>0, AVERAGE(B3434),"")

 

[Angelsnecropolis]

Thanks for the help. That worked.

I think that you mean

=IF(COUNT(B3434)>0, AVERAGE(B3434),"")

or even

=IF(COUNT(B3434), AVERAGE(B3434),"")



--
__________________________________
HTH

Bob

 

[Shane Devenshire]

Hi,

If you are using 2007 try this

=IFERROR(AVERAGE(B3434),"")