Formula help

Options

I am sure this is an easy formula and I am having a hard time figuring it out.

I am trying to use a formula that will sum up the total from this sheet based on the following:

I want the total amount summarized for a specific Fleet Number. For example, there are 2 entries for BB0695. I want the sum of those added to my other sheet.

The fleet number will change so I want a formula that will apply to any new rows that are added. I was trying to use the @row function but having trouble.



Answers

  • James Keuning
    James Keuning ✭✭✭✭✭
    Options

    Look at SUMIF

    SUMIF([Fleet Number]:[Fleet Number],"BB0695",Amount:Amount)

    On your other sheet you will need to keep a list of each fleet number, and each fleet number record in that sheet will get updated sums when this sheet.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!