I am trying to create a google sheet where the yearly sum is going to be 40 and I want that number to countdown as I enter monthly values. So if I have 2 of a thing in January, the sum goes down to 38 automatically. I cannot figure out how to do that and I do not even know what that is called in order to search for it. Can anyone help? Thank you!
In Excel cells cannot modify their contents.
You could have a starting number in a cell that never changes.
And a list in a column where items get added to.
You could then have a yearly sum cell that is a calculation of (starting cell - number of items in list column)
So in A1 put 40
Enter monthly values in column B
in C1 yearly sum would be A1 - SUM(B1:B1000)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
From your brief description it is difficult to know exactly what you are trying to do.
Any one of these functions may suit the true objective:
=40-SUM()
=40-COUNT()
=40-SUMIF()
=40-COUNTIF()
=40-SUMIFS()
=40-COUNTIFS()
Here is a link to a sample file create for you to build a sample into:
https://docs.google.com/spreadsheets...#gid=953131243
I suggest you take some time to create a realistic sample of your true objective.
Let us know when that is done.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks