If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problems with array
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. |
#2
|
|||
|
|||
Problems with array
Hi
try the array formula =IF(AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))=0 ,"", AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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. |
#3
|
|||
|
|||
Problems with array
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 wrote in message ... Hi try the array formula =IF(AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))= 0,"", AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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. |
#4
|
|||
|
|||
Problems with array
Hi
try =IF(AVERAGE(IF(sheet2!c27:e50"",sheet2!c27:e50)) =0,"", AVERAGE(IF(sheet2!c27:e50"",sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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 wrote in message ... Hi try the array formula =IF(AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))=0 ,"", AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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. |
#5
|
|||
|
|||
Problems with array
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 try =IF(AVERAGE(IF(sheet2!c27:e50"",sheet2!c27:e50) )=0,"", AVERAGE(IF(sheet2!c27:e50"",sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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 wrote in message ... Hi try the array formula =IF(AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))=0 ,"", AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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. |
#6
|
|||
|
|||
Problems with array
Hi
now I'm confused. In your first post you stated you don't want a zero. Now you want a zero? -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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 try =IF(AVERAGE(IF(sheet2!c27:e50"",sheet2!c27:e50)) =0,"", AVERAGE(IF(sheet2!c27:e50"",sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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 wrote in message ... Hi try the array formula =IF(AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))=0 ,"", AVERAGE(IF(sheet2!c27:e50,sheet2!c27:e50))) -- Regards Frank Kabel Frankfurt, Germany steve wrote: 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. |
Thread Tools | |
Display Modes | |
|
|