E
Ellen G
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(Janec!$CT19<>0,Janec!$CT19)
Any suggestions?
Thanks so much.
Ellen
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(Janec!$CT19<>0,Janec!$CT19)
Any suggestions?
Thanks so much.
Ellen