conditional totals per column

Hi all

Hoping I can find some help on this formula, Trying to figure out how to create sum totals of PO value column at the top of each of the first 3 columns (FERG JOB #, FVLV#, JOB SHOP #) if information is present in those cells. contingent on any of the items in the drop down list from PO/SDR down being selected.

Any help would be greatly appreciated! IF any further information is need please let me know and I will answer to the best of my limited abilities. lol, Thank you

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

SteyJ

You can use separate cell formulas for each column.

FERG JOB # Column

=SUMIFS([PO Value]:[PO Value], status:status, "PO/ SDR")

FVLV # Column

=SUMIFS([PO Value]:[PO Value], status:status, "PO/ SDR", [FVLV #]:[FVLV #], <>"")

Job Shop # Column

=SUMIFS([PO Value]:[PO Value], status:status, "PO/ SDR", [JOB SHOP #]:[JOB SHOP #], <>"")

Make sure the status criteria matches exactly with what is in the drop down option.

FabharChris

How would I add in another selection in addition to PO / SDR, How would I add that to the formula?

SteyJ

https://community.smartsheet.com/discussion/comment/410863#Comment_410863

Which column would you like to add an additional filter to the sumifs function?

FabharChris

so iif the status is one PO / SDR or Submitted or Approved they are all added together

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.