LinkBack URL
About LinkBacks
while writing formula how can i put table name if i am using insert function.
while writing in normal cell, table name comes automatically. but this does not happen when i write formula using insert function
while writing formula how can i put table name if i am using insert function.
while writing in normal cell, table name comes automatically. but this does not happen when i write formula using insert function
Hi Paramnayak,
I tried doing sum using Insert function and below is what I got :-
=SUM(Table1[@Column3],D4)
That means, table name comes when you enter formula using Insert Function option available on Ribbon Bar.
Can you upload your sample workbook to further investigate that. thx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
dear dilip,
is this happening in excel 2007.
say i write sum and select it using tab and than put ctrl + A. this will open insert function dialogue box. than how to get the table into it (without writing entire table 1[col 3].
in case i write in a normal cell, table 1 will come along with other function when i press t
rgds
Let me know if I am getting it correctly -> you wrote =Sum( in a cell, you pressed Tab to select table, you pressed ctrl +A to select entire table.select it using tab and than put ctrl + A. this will open insert function dialogue box.
Correct ?
Regards,
DILIPandey
<click on below * if this helps>
dear dilip,
yes i used ctrl + A that opens function argument. now here i want the table name
dear dilip,
what i am doing is in a cell type = and than sum and than select this function using tab and than cntrl +A that opens function argument. Now here I want to put the table without actually typing the entire table name
I am not getting it.. below is what I tried.
I typed below in a cell which is left side of a table :-
=sum(
and I pressed tab, it has given me a error " your formula is missing parenthesis ... "
But I tried, if you successfully give reference to table (either ways - typing function directly into a cell OR entering function using Insert function), the table name will appear.
Regards,
DILIPandey
<click on below * if this helps>
My above post #7 is a reply to your post #5,
Below is my reply to your post#6 :-
you typed "=" in a cell, and then ??what i am doing is in a cell type = and than sum and than select this function using tab and than cntrl +A that opens function argument. Now here I want to put the table without actually typing the entire table name
you typed "sum" OR,
you selected "sum icon" from menu bar OR,
you inserted "sum function" using Insert function option
I am interested to know how come pressing Ctrl + A opens Insert Function option
Also, Can you give your action - step by step.
Regards,
DILIPandey
<click on below * if this helps>
dear dilip
say the formula i want to insert in cell is =sum(table 1[col A]).
this can be done easily if i type in the cell ...... =su (all function with su in beginning will come and i can select sum from this and press tab. this will give =sum(
now if i type tabl , table 1 will appear. again i can select this and press tab. than typing [ will open all the columns in the table from which i can select the column.
now the same thing if i want to do using insert function than i press insert function than i select sum. this will open sum function argument. now here i want to put the table 1[col a] without actually typing the whole thing . how can this be done.
regarding cntrl + A ---it is short cut of opening the function argument. type =su this will give all functions starting with su. here i select sum and press tab this gives =sum( and than i put cntrl + A to open the sum function argument.
I created a table and on left side of this table, I selected a cell using my mouse cursor (that cell highlighted in yellow in below attachment)now the same thing if i want to do using insert function than i press insert function than i select sum. this will open sum function argument. now here i want to put the table 1[col a] without actually typing the whole thing . how can this be done.
I used ribbon menu option "Insert Function", I chosen SUM there.
In field "Number1", I selected first column in table and I got below:-
=SUM(Table1[[#All],[a]])
and I clearly see that table name captured there successfully.. not sure where you are stuck ?
table - sum.xlsx
Regards,
DILIPandey
<click on below * if this helps>
you don't get the intellisense prompts in the function wizard-you have to type the name or select the range with the mouse
Josie
if at first you don't succeed try doing it the way your wife told you to
thanx a lot --dilip and joseph
actually in excel option -- use table name in excel formula was unmarked.
hence i was not getting the table name.
thanx for the help
Great..!!
Thanks for sharing this.
Please mark this thread as [SOLVED]..
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks