Prev: Pivot Table Field Names
Next: Linked excel charts to Word doc
From: Eclaires on 3 Feb 2010 11:18
I am trying to work out a formula that calculates a figure from a certain
starting point in one worksheet and return the value in another worksheet

my formula so far is =sum(B12-F11)+STAPLES!H40

I need the formula to continue forever after H40 but am struggling to work
it out.

Any help would be much appreciated.

Best regards


Viv
From: Don Guillett on 3 Feb 2010 11:28
continue forever ???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Eclaires" <Eclaires(a)discussions.microsoft.com> wrote in message
news:6C911408-17A4-46DF-B693-B60671CB158F(a)microsoft.com...
>I am trying to work out a formula that calculates a figure from a certain
> starting point in one worksheet and return the value in another worksheet
>
> my formula so far is =sum(B12-F11)+STAPLES!H40
>
> I need the formula to continue forever after H40 but am struggling to work
> it out.
>
> Any help would be much appreciated.
>
> Best regards
>
>
> Viv

From: Fred Smith on 3 Feb 2010 11:42
You'll need to define what "continue forever" is. As an aside, you don't
need the Sum function in your formula,
=B12-F11+STAPLES!H40

will work just as well.

Regards,
Fred

"Eclaires" <Eclaires(a)discussions.microsoft.com> wrote in message
news:6C911408-17A4-46DF-B693-B60671CB158F(a)microsoft.com...
>I am trying to work out a formula that calculates a figure from a certain
> starting point in one worksheet and return the value in another worksheet
>
> my formula so far is =sum(B12-F11)+STAPLES!H40
>
> I need the formula to continue forever after H40 but am struggling to work
> it out.
>
> Any help would be much appreciated.
>
> Best regards
>
>
> Viv

From: "David Biddulph" groups [at] on 3 Feb 2010 11:46
You may need to explain what you are trying to do.

1 What do you mean by "continue forever after H40"?

2 What are you wanting the SUM function to do in =sum(B12-F11)? In what
way do you want the result of that to differ from =B12-F11 ? Do you need to
look up the SUM function in Excel help?
--
David Biddulph


"Eclaires" <Eclaires(a)discussions.microsoft.com> wrote in message
news:6C911408-17A4-46DF-B693-B60671CB158F(a)microsoft.com...
>I am trying to work out a formula that calculates a figure from a certain
> starting point in one worksheet and return the value in another worksheet
>
> my formula so far is =sum(B12-F11)+STAPLES!H40
>
> I need the formula to continue forever after H40 but am struggling to work
> it out.
>
> Any help would be much appreciated.
>
> Best regards
>
>
> Viv


 | 
Pages: 1
Prev: Pivot Table Field Names
Next: Linked excel charts to Word doc