Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function & column labels
Hi Sridhar,
What you use is called "Natural Language formulas" enabled by "Accept labels in formulas" This feature only works on the same sheet. It is not recommended anyway and has been removed in Excel 2007. Use explicitly defined names instead: InsertNameDefine. No use for sheet qualifiers, but they can still be used (although they are tricky and also not recommended!) -- Kind regards, Niek Otten Microsoft MVP - Excel "yshridhar" wrote in message ... | =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 | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function & column labels
Thanks Mr. Niek. I will follow your suggestion.
With regards Sridhar "Niek Otten" wrote: Hi Sridhar, What you use is called "Natural Language formulas" enabled by "Accept labels in formulas" This feature only works on the same sheet. It is not recommended anyway and has been removed in Excel 2007. Use explicitly defined names instead: InsertNameDefine. No use for sheet qualifiers, but they can still be used (although they are tricky and also not recommended!) -- Kind regards, Niek Otten Microsoft MVP - Excel "yshridhar" wrote in message ... | =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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column labels | Excel Discussion (Misc queries) | |||
column labels | Setting up and Configuration of Excel | |||
Column Labels | Excel Discussion (Misc queries) | |||
row and column labels | Excel Discussion (Misc queries) | |||
Column Labels | Excel Discussion (Misc queries) |