Jan 27 2021 11:31 AM
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.
Jan 27 2021 11:55 AM
Try this formula:
=divforbrukstabeller[[#Sum],[columnname]]
where columnname is the field name/column header of column C.
Jan 28 2021 10:48 AM
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.
Jan 28 2021 11:33 AM
I'd have to see a copy of the workbook.
Jan 28 2021 11:41 AM
Jan 30 2021 05:34 AM
Jan 30 2021 07:54 AM
@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.
Feb 11 2021 12:42 PM
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.