Subtraction formula that is based on another formula

Hi everyone,

Please send help.

I have a formula set up to calculate total costs. However, I need to have it set up so that the total amount subtracts from a budget total.

For example, say the budget it 20,000. I need the =SUM(Amount:Amount) to automatically subtract from the 20,000.

I hope this makes sense. Thank you!

Find more posts tagged with

Accepted answers

Mark.poole

@cdeplato

=20,000-Sum(Amount:Amount)

Just replace the 20,000 with the cell reference of your budget total

All comments

Mark.poole

@cdeplato

=20,000-Sum(Amount:Amount)

Just replace the 20,000 with the cell reference of your budget total

cdeplato

Thank you so much!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.