Need support using wildcard & sumif function
Hello, I have a sheet that's I'm trying to use the sumif function in, but I'm trying to base the criteria on a wildcard.
For reference this is a sample sheet I made, and the wild card formula works fine in excel. Essentially, I want to SUM the values in the "RoleValue" column for a specific condition in the Quarter column.. So if the Quarter Column has a Q2-2024 in it, it will sum each corresponding RoleValue cell that matches that (in this case the value would be 3.1. If I query for Q3-2024 the Total value would be 1.8. I can get this to work in excel with the example formula I wrote out in Column5 row2, but I don't know how to do this in smartsheets. I've tried a few combinations of using sumif and contains, but no luck. Any support on solving this would be appreciated. Thank you!
Best Answer
Answers
-
-
This formula does exactly what I was looking for! Thanks so much, Parul.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives