I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are
blank, I would like to return a blank cell. If any of the 3 cells has a
value, I would like to return the average.

I am familar with how to do this based on 1 cell, but confused as to how to
get it to work with 3!

=IF(AND(A6="",C6="",E6=""),"",AVERAGE(A6,C6,E6))

WAR wrote:
> I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are
> blank, I would like to return a blank cell. If any of the 3 cells has a
> value, I would like to return the average.
>
> I am familar with how to do this based on 1 cell, but confused as to how to
> get it to work with 3!

=IF(COUNTA(A6,C6,E6)=0,"",AVERAGE(A6,C6,E6))
Bob Umlas
Excel MVP

"WAR" <(E-Mail Removed)> wrote in message
news:645AFD41-D507-47BA-B2E0-(E-Mail Removed)...
> I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are
> blank, I would like to return a blank cell. If any of the 3 cells has a
> value, I would like to return the average.
>
> I am familar with how to do this based on 1 cell, but confused as to how
> to
> get it to work with 3!

=if(and(a6="",c6="",e6=""),"",average(a6:c6)
--
If this helps, please remember to click yes.


"WAR" wrote:

> I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are
> blank, I would like to return a blank cell. If any of the 3 cells has a
> value, I would like to return the average.
>
> I am familar with how to do this based on 1 cell, but confused as to how to
> get it to work with 3!

Thanks, Paul for your timely answer . . . back to work!

"Paul C" wrote:

> =if(and(a6="",c6="",e6=""),"",average(a6:c6)
> --
> If this helps, please remember to click yes.
>
>
> "WAR" wrote:
>
> > I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are
> > blank, I would like to return a blank cell. If any of the 3 cells has a
> > value, I would like to return the average.
> >
> > I am familar with how to do this based on 1 cell, but confused as to how to
> > get it to work with 3!