Average SUMof mutilple cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

speakez - 23 Jan 2006 00:39 GMT

ok i have a dilemma, im pretty new to excel and havent been able to find
the solution anywhere on google.

in cells C14,E14,G14,I14,K14,M14 i have SUM functions, I want to
average the results of the SUM functions in another cell, however i
wish to skip over the cells that have zeros.

how can i do this?

any help is appreciated.

Thank You

Signature

speakez

Reply to this Message

Gary''s Student - 23 Jan 2006 00:57 GMT

AVERAGE() will automatically exclude blanks, but not zeros, so lets make
zeros into blanks:

Suppose that C14 has something like A1+B1 as the formula. Instead of:
=A1+B1
use
=if(A1+B1=0,"",A1+B1)

Now C14 will be blank rather than zero, and the AVERAGE() won't include it.

Signature

Gary's Student

> ok i have a dilemma, im pretty new to excel and havent been able to find
> the solution anywhere on google.
[quoted text clipped - 8 lines]
>
> Thank You

Reply to this Message

speakez - 23 Jan 2006 01:06 GMT

awesome, that works perfectly. Thank You

Signature

speakez

Reply to this Message