Good afternoon
I have read through the historic threads and am aware that I am asking a
very similar (if not the same!!!) question that others have, but i have a
problem that I just can't seem to get my head around...

Cells AB5:AB67 contain week numbers
Cells N5:N67 contain the result of a formula that is providing a daily
average of telephone calls answered.

I am using the following formula to calculate that if the calls were
answered within week 37, to return the value of the average number of calls
taken within this week. As I am looking at a fixed period for the next 12
weeks, I have a table that has all the formulas entered in order that as the
daily stats are available I can enter the numbers and the rest is produced
automatically. For this reason some of the cells contain a zero which is
resulting in a return of #DIV/01!. I thought this formula would remove this,
but it doesn't.

=AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call Handling
Data'!$N$5:$N$67),'Call Handling Data'!$N$5:$N$67))))
(Entered as an array)

Please can somebody help me ?!?!
Many thanks

Rebekah,

I cannot replicate this problem.

Where are these formulae, and what are they?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rebekah" wrote in message
...
Good afternoon
I have read through the historic threads and am aware that I am asking a
very similar (if not the same!!!) question that others have, but i have a
problem that I just can't seem to get my head around...

Cells AB5:AB67 contain week numbers
Cells N5:N67 contain the result of a formula that is providing a daily
average of telephone calls answered.

I am using the following formula to calculate that if the calls were
answered within week 37, to return the value of the average number of
calls
taken within this week. As I am looking at a fixed period for the next 12
weeks, I have a table that has all the formulas entered in order that as
the
daily stats are available I can enter the numbers and the rest is produced
automatically. For this reason some of the cells contain a zero which is
resulting in a return of #DIV/01!. I thought this formula would remove
this,
but it doesn't.

=AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call
Handling
Data'!$N$5:$N$67),'Call Handling Data'!$N$5:$N$67))))
(Entered as an array)

Please can somebody help me ?!?!
Many thanks

Sorry..? Do you mean the formulas feeding this average?

Would it help for me to email a copy of the spreadsheet?



"Bob Phillips" wrote:

Rebekah,

I cannot replicate this problem.

Where are these formulae, and what are they?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rebekah" wrote in message
...
Good afternoon
I have read through the historic threads and am aware that I am asking a
very similar (if not the same!!!) question that others have, but i have a
problem that I just can't seem to get my head around...

Cells AB5:AB67 contain week numbers
Cells N5:N67 contain the result of a formula that is providing a daily
average of telephone calls answered.

I am using the following formula to calculate that if the calls were
answered within week 37, to return the value of the average number of
calls
taken within this week. As I am looking at a fixed period for the next 12
weeks, I have a table that has all the formulas entered in order that as
the
daily stats are available I can enter the numbers and the rest is produced
automatically. For this reason some of the cells contain a zero which is
resulting in a return of #DIV/01!. I thought this formula would remove
this,
but it doesn't.

=AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call
Handling
Data'!$N$5:$N$67),'Call Handling Data'!$N$5:$N$67))))
(Entered as an array)

Please can somebody help me ?!?!
Many thanks

Do you perhaps have div errors in the range itself? There is nothing wrong
with your formula


--


Regards,


Peo Sjoblom



"Rebekah" wrote in message
...
Sorry..? Do you mean the formulas feeding this average?

Would it help for me to email a copy of the spreadsheet?



"Bob Phillips" wrote:

Rebekah,

I cannot replicate this problem.

Where are these formulae, and what are they?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rebekah" wrote in message
...
Good afternoon
I have read through the historic threads and am aware that I am asking
a
very similar (if not the same!!!) question that others have, but i have
a
problem that I just can't seem to get my head around...

Cells AB5:AB67 contain week numbers
Cells N5:N67 contain the result of a formula that is providing a daily
average of telephone calls answered.

I am using the following formula to calculate that if the calls were
answered within week 37, to return the value of the average number of
calls
taken within this week. As I am looking at a fixed period for the next
12
weeks, I have a table that has all the formulas entered in order that
as
the
daily stats are available I can enter the numbers and the rest is
produced
automatically. For this reason some of the cells contain a zero which
is
resulting in a return of #DIV/01!. I thought this formula would remove
this,
but it doesn't.

=AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call
Handling
Data'!$N$5:$N$67),'Call Handling Data'!$N$5:$N$67))))
(Entered as an array)

Please can somebody help me ?!?!
Many thanks

Yes I do, but you can send it if you wish (note my signature)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rebekah" wrote in message
...
Sorry..? Do you mean the formulas feeding this average?

Would it help for me to email a copy of the spreadsheet?



"Bob Phillips" wrote:

Rebekah,

I cannot replicate this problem.

Where are these formulae, and what are they?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rebekah" wrote in message
...
Good afternoon
I have read through the historic threads and am aware that I am asking
a
very similar (if not the same!!!) question that others have, but i have
a
problem that I just can't seem to get my head around...

Cells AB5:AB67 contain week numbers
Cells N5:N67 contain the result of a formula that is providing a daily
average of telephone calls answered.

I am using the following formula to calculate that if the calls were
answered within week 37, to return the value of the average number of
calls
taken within this week. As I am looking at a fixed period for the next
12
weeks, I have a table that has all the formulas entered in order that
as
the
daily stats are available I can enter the numbers and the rest is
produced
automatically. For this reason some of the cells contain a zero which
is
resulting in a return of #DIV/01!. I thought this formula would remove
this,
but it doesn't.

=AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call
Handling
Data'!$N$5:$N$67),'Call Handling Data'!$N$5:$N$67))))
(Entered as an array)

Please can somebody help me ?!?!
Many thanks

Hi Bob

I have sent you an email to an address I have assumed....

Please can you let me know if you have received it?
Many thanks

"Bob Phillips" wrote:

Yes I do, but you can send it if you wish (note my signature)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rebekah" wrote in message
...
Sorry..? Do you mean the formulas feeding this average?

Would it help for me to email a copy of the spreadsheet?



"Bob Phillips" wrote:

Rebekah,

I cannot replicate this problem.

Where are these formulae, and what are they?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rebekah" wrote in message
...
Good afternoon
I have read through the historic threads and am aware that I am asking
a
very similar (if not the same!!!) question that others have, but i have
a
problem that I just can't seem to get my head around...

Cells AB5:AB67 contain week numbers
Cells N5:N67 contain the result of a formula that is providing a daily
average of telephone calls answered.

I am using the following formula to calculate that if the calls were
answered within week 37, to return the value of the average number of
calls
taken within this week. As I am looking at a fixed period for the next
12
weeks, I have a table that has all the formulas entered in order that
as
the
daily stats are available I can enter the numbers and the rest is
produced
automatically. For this reason some of the cells contain a zero which
is
resulting in a return of #DIV/01!. I thought this formula would remove
this,
but it doesn't.

=AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call
Handling
Data'!$N$5:$N$67),'Call Handling Data'!$N$5:$N$67))))
(Entered as an array)

Please can somebody help me ?!?!
Many thanks

Rebekah,

I haven't received it yet.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rebekah" wrote in message
...
Hi Bob

I have sent you an email to an address I have assumed....

Please can you let me know if you have received it?
Many thanks

"Bob Phillips" wrote:

Yes I do, but you can send it if you wish (note my signature)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rebekah" wrote in message
...
Sorry..? Do you mean the formulas feeding this average?

Would it help for me to email a copy of the spreadsheet?



"Bob Phillips" wrote:

Rebekah,

I cannot replicate this problem.

Where are these formulae, and what are they?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rebekah" wrote in message
...
Good afternoon
I have read through the historic threads and am aware that I am
asking
a
very similar (if not the same!!!) question that others have, but i
have
a
problem that I just can't seem to get my head around...

Cells AB5:AB67 contain week numbers
Cells N5:N67 contain the result of a formula that is providing a
daily
average of telephone calls answered.

I am using the following formula to calculate that if the calls were
answered within week 37, to return the value of the average number
of
calls
taken within this week. As I am looking at a fixed period for the
next
12
weeks, I have a table that has all the formulas entered in order
that
as
the
daily stats are available I can enter the numbers and the rest is
produced
automatically. For this reason some of the cells contain a zero
which
is
resulting in a return of #DIV/01!. I thought this formula would
remove
this,
but it doesn't.

=AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call
Handling
Data'!$N$5:$N$67),'Call Handling Data'!$N$5:$N$67))))
(Entered as an array)

Please can somebody help me ?!?!
Many thanks