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.
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!