I need help with excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2103304%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103304%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20a%20question.%20Is%20there%20any%20formula%20or%20something%20that%20can%20help%20me%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20one%20column%20that%20is%20summarized%2C%20in%20cell%20C21%2C%20but%20i%20would%20like%20it%20to%20show%20up%2C%20in%20B36%20in%20an%20table%20on%20a%20different%20sheet.%20So%20when%20i%20make%20a%20change%20in%20the%20summarize%20table%2C%20it%20automatically%20changes%20in%20the%20cell%20B36.%20Is%20it%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20summarize%20table%3D%20divforbrukstabeller%3C%2FP%3E%3CP%3EThe%20table%20i%20want%20it%20to%20show%20up%20in%3D%20Faktiskforbruk%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20taken%20some%20screenshots%20of%20the%20tables%20so%20you%20can%20se%2C%20and%20se%20if%20it%20makes%20sense.%20The%20only%20cell%20there's%20is%20a%20formula%20inn%20is%20C21.%20The%20formula%20is%20%3DSUM(C2%3AC20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20there's%20any%20question%20just%20ask.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2103304%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2103368%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F945024%22%20target%3D%22_blank%22%3E%40Stig_Andre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20this%20formula%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3Ddivforbrukstabeller%5B%5B%23Sum%5D%2C%5B%3CEM%3Ecolumnname%3C%2FEM%3E%5D%5D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewhere%20%3CEM%3Ecolumnname%3C%2FEM%3E%20is%20the%20field%20name%2Fcolumn%20header%20of%20column%20C.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi

 

I need help with a question. Is there any formula or something that can help me? 

 

I have one column that is summarized, in cell C21, but i would like it to show up, in B36 in an table on a different sheet. So when i make a change in the summarize table, it automatically changes in the cell B36. Is it possible?

 

The summarize table= divforbrukstabeller

The table i want it to show up in= Faktiskforbruk

 

I have taken some screenshots of the tables so you can se, and se if it makes sense. The only cell there's is a formula inn is C21. The formula is =SUM(C2:C20)

 

If there's any question just ask.

 

7 Replies

@Stig_Andre 

Try this formula:

 

=divforbrukstabeller[[#Sum],[columnname]]

 

where columnname is the field name/column header of column C.

@Hans Vogelaar 

 

Hi thanks fore response.

 

I have tried your formula, and I dont seem to get i right. I keep getting an error mark. You can see it in the screenshot.

@Stig_Andre 

I'd have to see a copy of the workbook.

@Stig_Andre 

I guess there is no Total Row in the table

image.png

@Hans Vogelaar @Sergei Baklan 

 

Thank's for your help. I found a way to do it.

@Stig_Andre , great to know, thank you for the update. I only not sure why do you need structured table if you use it as range.

@Sergei Baklan 

 

Hi

 

I have one table where i putt in all the small amounts in an budget like grocery's, and that table summarize the small amounts and puts it in, in-another sheet where i keep an overview over the expenses in my budget. That way I don't need to manually summarize and correct the cell.