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.