Formula help

JennS_

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.

James Keuning

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.