Excel Formula across Worksheets 1

[marshyrob]

Hello

Im trying to get a simple calculation working in Excel

I have 4 worksheets that are the monthly quarters and i want the add up the same range on all 4 sheets, but i also need to start with 30 as the number to subtract from the result of the range:

I tried this:

=SUM(30-('Jan-Mar:Oct-Dec'!C8:CN8))

But i get #VALUE

If i take the 30- and related brackets i get 0 which is correct as there are no values in the cell range yet but i need to calculate the range subtracting from 30.

Anyone see the error of my ways?

Thanks

Rob

 

[SkipVought]

hi,
[tt]
=30-SUM('Jan-Mar:Oct-Dec'!C8:CN8)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[marshyrob]

ahh damn it!! Schoolboy error, thanks skip top man!