Excel - Need Average - Without Zeros - Not Continuous

[CptDavid]

Hi all,

I have cells, say A2, A4, A6, etc. that I need to average, but also need to exclude any of those cells that have a zero value.

Any thoughts?

Thanks!

 

[SkipVought]

hi,

[tt]
Sum(TheRange)/COUNITF(TheRange,">0")
[/tt]


Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[SkipVought]

Should have made the criteria "<>0"

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}