Problems with array

[steve]

Hello,
I have been trying for awhile now in fixing this problem that I am
having with this array and since I am getting no where I thought I might ask
here for some help. Here is what I have:
date time day evening night 24hrs.
total cc\hour avg. cc\day avg. cc\week
5/14/04 0
5/14/04 0
5/14/04 0
5/14/04
0 0 0 0 *
5/15/04 200
5/15/04 375
5/15/04 0
5/15/04 100
5/15/04 300
5/15/04
1550 64.58 387.5
5/21/04 0
5/21/04 0
5/21/04 0
5/21/04
0 0 0

For the avg. cc\week I am using the array formula =
average(if(sheet2!c27:e50<>,sheet2!c27:e50)) ctr + shift + enter. The
problems that I am having it does not want to print the 0 for avg. cc\week
on 5/14/04.

 

[Frank Kabel]

Hi
try the array formula
=IF(AVERAGE(IF(sheet2!c27:e50<>,sheet2!c27:e50))=0,"",
AVERAGE(IF(sheet2!c27:e50<>,sheet2!c27:e50)))

 

[steve]

Hello Mr. Kabel,
I tried that formula and I used the cntrl + shift +enter like the other
array and I used instead of c27:e50 to c2:e25 and I got everytime a formula
error.
Any suggestions
thanks

 

[Frank Kabel]

Hi
try
=IF(AVERAGE(IF(sheet2!c27:e50<>"",sheet2!c27:e50))=0,"",
AVERAGE(IF(sheet2!c27:e50<>"",sheet2!c27:e50)))

 

[steve]

Hello,
Well it is getting closer to what I want. Like I said,"I changed the c27:e50
to c2:e25 and added your array and know I got a blank which I read in the
help file I should get this but is there away to print the number zero.
Maybe this can not be done.
thanks for your help
Frank Kabel wrote in message ...

 

[Frank Kabel]

Hi
now I'm confused. In your first post you stated you don't want a zero.
Now you want a zero?