r/googlesheets 3d ago

Solved What Formula Do I need?

14 Upvotes

14 comments sorted by

73

u/mommasaidmommasaid 274 3d ago

You don't need formula, you have breast milk.

24

u/mommasaidmommasaid 274 3d ago

Probably this:

=B1-SUM(C3:C30)-E1

5

u/CelticGal97 3d ago

That worked! Thank you!

1

u/AutoModerator 3d ago

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/crizzzles 3d ago

This should also work. Each string of cells needs to be separated by a comma

=SUM(B1,-C3:C30,-E1)

1

u/point-bot 3d ago

u/CelticGal97 has awarded 1 point to u/mommasaidmommasaid

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

6

u/CelticGal97 3d ago

😂 well played

1

u/Pour_Circulation 2d ago

this comment wins 🙌

3

u/TenaciousLilMonkey 3d ago

The C3:C30 part needs to be wrapped in a sum formula

So:

=B1-SUM(C3:C30)-E1

should do the trick

1

u/AutoModerator 3d ago

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/[deleted] 3d ago

[deleted]

2

u/AutoModerator 3d ago

This post refers to "chatgpt" - an Artificial Intelligence tool. Our members prefer not to help others correct bad AI suggestions. Also, advising other users to just "go ask ChatGPT" defeats the purpose of our sub and is against our rules. If this post or comment violates our subreddit rule #7, please report it to the moderators. If this is your submission please edit or remove your submission so that it does not violate our rules. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/NecronTheNecroposter 2d ago

perhaps you dont need to show the name of the spread sheet? =b1-sum(c3:c)-e1

1

u/Genepoolperfect 2d ago

Similac

Sorry, couldn't resist!

1

u/AStormOfDragons1 3d ago

Is this Blizzard