If you want to avoid the #DIV/0! problem, you could try
=IF(COUNT(C43,P37)=2,AVERAGE(C43,P37),"")
--
David Biddulph

"Liana" wrote in message
...
I have a formula on my worksheet which is trying to calculate a weekly
average but the daily average is made up of 2 different percentages
=AVERAGE(C43,P37) the trouble is if there is a blank day eg a bank holiday
then the average is DIV#0!, I know I need to do an IF sum but how do I do
it
when the 2 averages are added, I have tried to do first:last(cell no) but
if
there is a blank day then I get no weekly total
Can anyone help ?

"Roger Govier" wrote:

Hi Liana

Don't give up, it will work.
If you want to mail me a copy of your workbook, I will take a look.
to mail direct send to
roger at technology4u dot co dot uk
Change the at and dots to the obvious.

--

Regards
Roger Govier

"Liana" wrote in message
...
My workbook is laid out exactly that way , I am now beginning to give
up
just
when I thought I was getting the hang of it all !!

"Roger Govier" wrote:

Hi Liana

Your sheet order should be
Summary Sheet with your Sum formula
First (Blank)
Sheet1
..
..
Sheet19
Last (Blank)

The Summary sheet can be before First, or after Last, but should not
be
in
between.
--

Regards
Roger Govier

"Liana" wrote in message
...
I have managed to get a total for one sum but if I try with the
other 2
totals in the same way I still get a zero figure..

"David Biddulph" wrote:

You missed out a small but important exclamation mark.
It should be =SUM(first:last!B48)
--
David Biddulph

"Liana" wrote in message
...
=SUM(first:lastB48), I also tried sum= () to which I clicked on
every
persons monthly total cell & hoped to get an answer - still no
luck

"David Biddulph" wrote:

Exactly what did your formula look like?
--
David Biddulph

"Liana" wrote in message
...
I am trying to sum totals from 19 pages, I have entered 2 dummy
sheets
at
the
beginning & end & now want monthly totals. each worksheet has
monthly
totals
but I need the overall month for the whole team, I tried
sum(first:last
cell
number) but the answer is zero - what am I missing ?