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 Q22024 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 Q32024 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
 Smartsheet Customer Resources
 62.9K Get Help
 377 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives