=AVERAGE returning a #DIV/0! result

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
 
Sorry..? Do you mean the formulas feeding this average?

Would it help for me to email a copy of the spreadsheet?
 
Do you perhaps have div errors in the range itself? There is nothing wrong
with your formula


--


Regards,


Peo Sjoblom
 
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)
 
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
 
Rebekah,

I haven't received it yet.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
 
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)
 
Back
Top