if there is a way to do a simple formula

Well, simple being relative! <g

Assuming the values to average are positive:

=SUM(Jan:Dec!CT19)/SUMPRODUCT(COUNTIF(INDIRECT(TEXT(ROW(INDIRECT("1:1 2"))*30,"mmm")&"!CT19"),"0"))

Or , if your OK with using an add-in...

Download and install the free Morefunc.xll add-in from:

http://xcell05.free.fr/morefunc/english/index.htm

Then use this array formula:

=AVERAGE(IF(THREED(Jan:Dec!CT19),THREED(Jan:Dec!CT 19)))

--
Biff
Microsoft Excel MVP


"Ellen G" wrote in message
...
That would certainly work, however I'd love to know if there is a way to
do a
simple formula so I don't have to store in the information twice (once in
the
individual cells and once on another sheet).

Thanks for your help.

Ellen

"Ellen G" wrote:

Hi there --

I have a workbook with a tab for each month (i.e. Jan, Feb, Mar...Dec).

I need to AVERAGE CT19 in each. And, I don't want to include any that are
0.
So, I've tried the following, but it doesn't work. (I have tried this
both as
an array and not an array.)

=AVERAGE(IF(Jan:Dec!$CT19<0,Jan:Dec!$CT19)

Any suggestions?

Thanks so much.

Ellen