Summing multiple cells from another sheet, formula not working?

[Overdahill]

Hi,

I'm trying to create a formula where I sum multiple cells, from other pages in one formula?

So I have 5 pages, named 1st, 2nd, 3rd, 4th & 5th.

In cells B101, B102 & B103 is data I need to summarise, however in B101 I need to divide this by 2.

So I tried to do the following: =SUM('1st:5th'!B101/2)+('1st:5th'!B102)+('1st:5th'!B103)

But it doesn't work?

Can anyone help here?

Thanks in advance.

[leprince2007]

Try this

Please Login or Register  to view this content.