Use the content of a cell in the sum (or other) functions

Posted to microsoft.public.excel.misc

Gary''s Student Gary''s Student is offline

external usenet poster

Posts: 11,058

Use the content of a cell in the sum (or other) functions

=SUM(INDIRECT(D1))

--
Gary''s Student - gsnu200781

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
copy comment content to cell content as data not as comment	Lilach	Excel Discussion (Misc queries)	2	June 21st 07 12:28 PM
How make hyperlink refer to cell content rather than cell address.	Omunene	Excel Discussion (Misc queries)	3	March 2nd 06 01:07 AM
Conditional cell background formatting, based on cell content	nosivad	Excel Discussion (Misc queries)	5	February 11th 06 11:12 PM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	1	February 11th 05 06:36 AM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	0	February 11th 05 05:35 AM

All times are GMT +1. The time now is 06:04 AM.

About Us