=AVERAGE returning a #DIV/0! result
 

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

=AVERAGE returning a #DIV/0! result
 

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

=AVERAGE returning a #DIV/0! result
 

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

=AVERAGE returning a #DIV/0! result
 

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

=AVERAGE returning a #DIV/0! result
 

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

=AVERAGE returning a #DIV/0! result
 

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

=AVERAGE returning a #DIV/0! result
 

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

=AVERAGE returning a #DIV/0! result
 

Hi Bob
I have tried several different options to guess your email address but I
haven't got it right...
I can't access personal mails at work and I'm sure work wouldn't be happy
for me to post my work one, so I guess thats that! Thanks anyway!

Beks

"Bob Phillips" wrote:

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

=AVERAGE returning a #DIV/0! result
 

Rebekah,

My email is

bob dot ngs at gmail dot com

replace dot with . and at with @ and try again.

--
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 tried several different options to guess your email address but I
haven't got it right...
I can't access personal mails at work and I'm sure work wouldn't be happy
for me to post my work one, so I guess thats that! Thanks anyway!

Beks

"Bob Phillips" wrote:

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