Calculating sum of Receipt Totals from another sheet based on criteria of 3 columns

MACChelsea

Hello,

I am trying to build a metrics sheet to put into my new dashboard. This workspace includes receipts/ invoices that have been submitted by employees. On the Metrics sheet, I have the following columns- Branch, Field Cost Center, Charge Account, Auto Code, Total (YTD). I am trying to pull the receipt totals from another sheet, Submission Sheet, based on the criteria matching the branch, field cost center, and charge account to be placed in the Total (YTD) column of the metrics sheet.

Basically, I want to get the grand total of each receipt that was submitted to each charge account for each branch.

Paul Newcome

You are going to want a SUMIFS function:

https://help.smartsheet.com/function/sumifs

.