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?
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.
-
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?
-
@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. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!