=AVERAGE returning a #DIV/0! result

G

Guest

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
 
B

Bob Phillips

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)
 
G

Guest

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

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

Peo Sjoblom

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


--


Regards,


Peo Sjoblom
 
B

Bob Phillips

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)
 
G

Guest

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
 
B

Bob Phillips

Rebekah,

I haven't received it yet.

--
HTH

Bob

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

Guest

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel =0/div 6
#DIV/0 3
LARGE Formula giving #DIV/0! 4
Formula that displays #DIV/0! 4
Averaging cells which contain #DIV/0! 7
IF with #DIV/0! 2
#DIV/0 ERROR in AVERAGING 7
#DIV/0! but why? 4

Top