how can create a formula to add data from 1 worksheet to another?

[Linnie]

how can create a formula to add data from 1 worksheet to another?

[Kassie]

Hi Linnie
You can use VLOOKUP, if it is based on info on the destination sheet. Would
need more info to help you there.

You can also reference the cell in the source sheet, by inserting a formula
in the destination cell. Say you want to put the data in Sheet1, cell A3,
and you want to read the data from Sheet2, Cell F8, then in Sheet1, cell A3,
enter the following formula: =Sheet2!F8.

HTH

"Linnie" wrote:

> how can create a formula to add data from 1 worksheet to another?

[Peo Sjoblom]

=Sheet2!A1+Sheet1!A1

or

=SUM(Sheet1:Sheet2!A1)

--
Regards,

Peo Sjoblom


"Linnie" <[email protected]> wrote in message
news:[email protected]...
> how can create a formula to add data from 1 worksheet to another?

[Byrone]

This helps a lot thanks, but what if you want to reference information from
another excel file. Is that possible?

"Kassie" wrote:

> Hi Linnie
> You can use VLOOKUP, if it is based on info on the destination sheet. Would
> need more info to help you there.
>
> You can also reference the cell in the source sheet, by inserting a formula
> in the destination cell. Say you want to put the data in Sheet1, cell A3,
> and you want to read the data from Sheet2, Cell F8, then in Sheet1, cell A3,
> enter the following formula: =Sheet2!F8.
>
> HTH
>
> "Linnie" wrote:
>
> > how can create a formula to add data from 1 worksheet to another?