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

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
|

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
|