Prev: excel 2003, list box:
Next: How to determine the ranking positions?
From: iguana2go on 6 Feb 2010 22:26
I want to create a summary worksheet which will total, say, worksheets
between a sheet called 'start' and a sheet called 'end' without typing the
individual sheet names, so that I can then insert sheets between those called
start and end without redoing the formula in my summary sheet. something
like
=sum(start!A3:end!A3)
but this doesn't work ... I know it can be done because i've done it before
I just can't work out how to do it now
From: Fred Smith on 6 Feb 2010 23:07
This way:
=sum(start:end!A3)

Regards,
Fred

"iguana2go" <iguana2go(a)discussions.microsoft.com> wrote in message
news:221734FE-A8FE-45F0-A731-B49793DC99BB(a)microsoft.com...
>I want to create a summary worksheet which will total, say, worksheets
> between a sheet called 'start' and a sheet called 'end' without typing the
> individual sheet names, so that I can then insert sheets between those
> called
> start and end without redoing the formula in my summary sheet. something
> like
> =sum(start!A3:end!A3)
> but this doesn't work ... I know it can be done because i've done it
> before
> I just can't work out how to do it now

 | 
Pages: 1
Prev: excel 2003, list box:
Next: How to determine the ranking positions?