Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speciefie table and not cells to sum
Hi,
I'm trying to make a summary in a specified tabell without have to specifie what start and end cell. So far I have done like this SUMMA.OMF(Januari!$C$4:$C$92;Januari!$A$4:$A$92;"= x") but I want something like this Summa.omf(Januari[#Allt] etc.... so that I can specifie column and tablename. I hope someone knows howe to do this. -- Best regards Mia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speciefie table and not cells to sum
Hi Mia,
I do not re ognize which language version you using. try: SUMMA.OMF(Januari!$C:$C;Januari!$A:$A;"=x") HTH, Wouter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speciefie table and not cells to sum
Hi,
Thank you so much for your help, it worked! I'm using swedish. -- Best regards Mia "Wouter HM" wrote: Hi Mia, I do not re ognize which language version you using. try: SUMMA.OMF(Januari!$C:$C;Januari!$A:$A;"=x") HTH, Wouter . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automaticily name cells in a table | Excel Discussion (Misc queries) | |||
changing table cells colours using a master table | Excel Discussion (Misc queries) | |||
Using 2 cells in a table to retrieve data from another table | Excel Worksheet Functions | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Can I connect Excel cells to cells in an embedded Word table? | Excel Discussion (Misc queries) |