Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel formula calculation

by tscottlaird Mar 6, 2006 6:28PM PST

have p4, 256 ddr, XP professional, 80gb hd. how to how to effect a formula in all the worksheets.for ex. sheet 0ne 6, sheet 2, 125 the total must arrive in the sheet second. Pl help.

sajini

Discussion is locked

1 Posts

- Collapse + Expand Details

- Collapse -

Re: Excel formulas

by Kees Bakker Mar 6, 2006 7:11PM PST

Sajini,

The full syntax for a cell reference is:
[workbookname]worksheetname!cell
and for a range
[workbookname]worksheetname!cell1:cell2
with workbookname defaulting to the current workbook, worksheetname defaulting to the current worksheet.

An example;
=sum([september.xls]TV!$B$1:$C$4)

If the workbookname contains spaces quotes are needed, e.g.
=sum('[revenue september.xls]TV'!$B$1:$C$4)

That's about all you need to know. And you can use the normal point and click way to build your formulas (they automatically get absolute addresses, as in the above example). Have a look in the Excel help under 'links', because that's what Excel calls a reference to another workbook.

Hope this helps.

Kees