How to total spend by month?

I am new to smart sheet attempting to create a budget tracker and will need to total the spend by month, for now just using actual spend. I tried a formula I saw online and keep receiving unparseable, could be user error though. Attaching a screenshot of the headers I am using and some fake data for testing. I may either pull this to another sheet, also open to recommendations on best way to do this. Thanks!

Formula: =SUMIFS([Expense Month]:[Expense Month], [Month #]@row, [Actual Spend]:[Actual Spend])

Find more posts tagged with

Formulas

Accepted answers

=Chris Palmer

Hello @AmandaBM,

Something like this perhaps?

=SUMIFS([Actual Spend]:[Actual Spend], [Expense Month]:[Expense Month], [Expense Month]@row)

All comments

=Chris Palmer

Hello @AmandaBM,

Something like this perhaps?

=SUMIFS([Actual Spend]:[Actual Spend], [Expense Month]:[Expense Month], [Expense Month]@row)

AmandaBM

That worked! Thanks, Mr. Chris. Another question, how would I be able to either pull that into another sheet? What would the formula look like?

=Chris Palmer

https://community.smartsheet.com/discussion/comment/412325#Comment_412325

Glad this worked for you!

To pull this into another sheet you'll need to enter the formula on your primary sheet, then click the "Reference Another Sheet" to find the ranges for your formula:

AmandaBM

Is it possible for us to chat about this if you have time this week?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.