Can someone help me get my SUMIF formula to work??
I am not as savvy as I want to be with SmartSheet, but I am hoping someone can help me manipulate this data the way I want to. I am trying to to summarize each individuals resource hours spent in meetings within a certain project. I have created a basic sheet that shows all of the meetings, the meeting length, and then who was in each meeting.
In my example, I am trying to summarize all of the hours Kara Mylerberg, who is in the UW dept, has spent in meetings. Here is the formula I used, however, it seems like it isn't able to recognize Kara's name?
Here is the same formula from the screen shot above:
=SUMIF(UW2:UW55, "Kara Mylerberg", [Meeting Length (minutes)]2:[Meeting Length (minutes)]41)
Here is a screen shot of the sheet:
Best Answer
-
Is that error anywhere within the UW column?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Try this...
=SUMIF(UW2:UW55, FIND("Kara Mylerberg", @cell) > 0, [Meeting Length (minutes)]2:[Meeting Length (minutes)]41)
You also need to make sure your ranges are the same size. Your range to sum is rows 2 - 55, but your criteria range is rows 2 - 41.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Erika,
I think the problem here comes from the difference of rows between your UW and Meeting Length ranges.
Try this :
=SUMIF(UW2:UW41, "Kara Mylerberg", [Meeting Length (minutes)]2:[Meeting Length (minutes)]41)
or that:
=SUMIF(UW:UW, "Kara Mylerberg", [Meeting Length (minutes)]:[Meeting Length (minutes)])
Have a good day,
Mathieu | Workflow Consultant
info@evolytion.com
-
Thank you, Paul! Good point on making sure both ranges are the same, I fixed that, but I am now getting "contact expected" error.
Here is the formula:
Any additional thoughts on how to troubleshoot this further?
-
Thank you Mathieu - I get the same error message with your suggested formula as well, the "contact expected" error. Any additional thoughts for me?? Thank you!
-
Is that error anywhere within the UW column?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome , thank you for your help! It ended up being a super easy fix. The "summary field" type was on "contact list..." instead of on "Text/Number". That is why it wasn't working. But now it is! Thank you for your help!
-
That was going to be my next question. Glad you figured it out and happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
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
Check out the Formula Handbook template!