Problems with array

  • Thread starter Thread starter steve
  • Start date Start date
S

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.
 
Hi
try the array formula
=IF(AVERAGE(IF(sheet2!c27:e50<>,sheet2!c27:e50))=0,"",
AVERAGE(IF(sheet2!c27:e50<>,sheet2!c27:e50)))
 
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
 
Hi
try
=IF(AVERAGE(IF(sheet2!c27:e50<>"",sheet2!c27:e50))=0,"",
AVERAGE(IF(sheet2!c27:e50<>"",sheet2!c27:e50)))
 
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 ...
 
Hi
now I'm confused. In your first post you stated you don't want a zero.
Now you want a zero?
 
Back
Top