Posted to microsoft.public.excel.misc

external usenet poster

Posts: 2

creating formulas

I am using Excel 2003. I have three different sheets-Sheet 1 through Sheet 1
(3). what i am trying to do is to add a particular cell from all 3 sheets.
I tried using this formula after using the help featu
=SUM(Sheet1:Sheet 1(3)!D34)

that doesnt seem to work. I even tried putting the sheets in single
quote-still didnt work. What did i do wrong?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating formulas	dorismgreene	Excel Discussion (Misc queries)	3	November 26th 07 02:19 AM
Creating Formulas	Lucille	Excel Worksheet Functions	2	April 26th 06 08:58 PM
Creating formulas	Lara Leigh	Excel Worksheet Functions	6	April 18th 06 06:06 PM
creating IF formulas in excel	Kowalskii	Excel Discussion (Misc queries)	2	July 27th 05 05:05 PM
Creating Formulas	samsmimi	Excel Worksheet Functions	3	March 29th 05 05:55 PM

All times are GMT +1. The time now is 10:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us