Formula help
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

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
Categories
Check out the Formula Handbook template!