Auto update changing totals

BruceBruce

New Member
Joined
Mar 8, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
First off thanks for adding me to the forum!

Hopefully I can explain this properly.

1: I have a categories column, I chose my categories via drop down list
2: The column next to categories is a money value.
3: After the entries have been made I run a total for each particular category
4: example Column A = categories, Column B = respective money entries, Column C = Category Totals

Say I have a category that has 10 entries, I use the formula =sum(B1:B10) and put that total in the C column cell C10
Then i go in the next day and add another entry to the particular category that would make my total in cell C10 no longer valid because now
i have 11 entries instead of 10.

Is there a way to have the C10 total value update regardless of how many entries I put in?

I hope I'm explaining this properly any help would be greatly appreciated.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

rachel06

Board Regular
Joined
Feb 3, 2016
Messages
54
Office Version
  1. 365
Platform
  1. Windows
Can you move the SUM to be above the data then SUM everything below it? Or make the formula something like =SUM(B1:B1000) ?
 

Forum statistics

Threads
1,144,154
Messages
5,722,815
Members
422,460
Latest member
VBA_Noob01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top