Average if not blank cells.

[excelnabb]

Hi

I need average formula that doesn't take into account blank cells, some of the cells are blank because there is a formula in the cells that goes like this:
=IF(OR(Parameters!F30="s",Parameters!F30="bc"),Parameters!I30,"")

I think I can use averageif, but I don't know how to edit it to exclude "blank" cells.
=AVERAGEIF(L7+P7+T7+X7+AB7)

[Phuocam]

Maybe like this?

=AVERAGE(L7,P7,T7,X7,AB7)

[Pepe Le Mokko]

Or the AVERAGEIF function including a <>"" condition?

[avk]

May be

Please Login or Register  to view this content.

[excelnabb]

I just get an #value error on all of them. I can also not use L7:B7, as that contains cells with values that should not be taken into account. ONLY the cells L7+P7+T7+X7+AB7

[AliGW]

There may be something fishy about the 'numbers' - are they just text instead?

Attach a sample workbook showing the problem. A small amount of data will do.

[excelnabb]

so cell x7 on day sheet

[avk]

You can define name as price.
Go to Name Manager > click New tab > Mention Name as Price > In Refers to enter =Day!$D$7,Day!$H$7,Day!$L$7,Day!$P$7,Day!$T$7 > Click on OK.
In X7 formula :

Please Login or Register  to view this content.

[XOR LX]

Why are you adding the cells?

What's wrong with the solution in post #2?

Regards

[avk]

Nothing wrong in post 2#.
I just give another solution.

[kvsrinivasamurthy]

Use
=AVERAGE(D7,H7,L7,P7,T7)

or

=AVERAGEIF($A$6:$T$6,"Price",$A7:$T7)

[excelnabb]

You guys are right, I didn't see that I had used + instead of ,
Thank you!

[Pepe Le Mokko]

Seeing that your columns are equally spaced, there are shorter possibilities than entering every cell in your syntax (if there are many more)