conditional totals per column

FabharChris

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

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