Posted to microsoft.public.excel.worksheet.functions

yshridhar

external usenet poster

Posts: 229

function & column labels

=sum(column label) do works in the respective sheet.
How to perform this =sum(sheet2!column label)
suppose i have a colum named Jan in Sheet1. Sum(Jan) works in Sheet1. I
want the SUM in sheet2 i.e., SUM(sheet1!Jan)
Thanks to you all
With regards
Sridhar

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
Column labels	steve-in-algarve	Excel Discussion (Misc queries)	4	February 6th 07 04:26 PM
column labels	s	Setting up and Configuration of Excel	1	August 16th 06 04:20 PM
Column Labels	Stephanie	Excel Discussion (Misc queries)	3	March 7th 05 06:23 PM
row and column labels	aron	Excel Discussion (Misc queries)	2	January 20th 05 11:41 PM
Column Labels	rosewalker	Excel Discussion (Misc queries)	1	December 2nd 04 03:15 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us