Average same cell in multiple sheets
The easiest way would be to link to each of those cells like this:
=Jan!CT19
=Feb!CT19
=Mar!CT19
......
=Dec!CT19
Then just average that range.
Array entered:
=AVERAGE(IF(A1:A12,A1:A12))
--
Biff
Microsoft Excel MVP
"Ellen G" wrote in message
...
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
|