Sum If & contains
Tim N
✭✭
Hi, Hoping for some help with a Sum IF formula. I would like to sum if from 'Sheet 2' Value based on Sheet 1 project code. I have tried the below formula utilising 'Contains' however it is returning 0 rather than sum of project 304.
Sheet 1
Sheet 2
Any assistance would be appreciated
Tags:
Answers
-
Hi @Tim N
Try this;
=SUMIF({Data Shuttle Report Range 1}, CONTAINS([Primary Column]@row, @cell), {Data Shuttle Report Range 2})
You need to use this format for the SUMIF function.
SUMIF(range, criterion, [sum_range])
range: {Data Shuttle Report Range 1}
criterion: CONTAINS([Primary Column]@row, @cell)
[sum_range]: {Data Shuttle Report Range 2}
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 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!