Hi.
I'm trying to figure out how I can have a single cell update to a new total of a column on a separate worksheet. I've been trying =sum('worksheet 2'!D:D) However, when I check the total, it's coming up a couple of hundred dollars off. The idea is to show when I charge something or make a credit card payment, I want a net worth sheet to update that account in a single box with the new total balance.
Thanks.
Cheers,
Chuck
I believe that you will require a VBA solution for this. If this is acceptable to you, then post back and we will provide it. It will fall under a worksheet change event.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I am a little confused. =sum(D:D) should work. Are you typing in the charges or payments in column D of Worksheet2?
are Calculation options set to AUTOMATIC under the Formulas ribbon?
Hi Eagle hater and welcome to the forum,
I think a Dynamic Named Range will solve your problem without needing VBA. See the attached where I've created a DNR on the Transactions sheet and summed it on the first sheet.
Sum using DNR.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks