Can someone help me get my SUMIF formula to work??

Erika Haskell

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:

Paul Newcome

Is that error anywhere within the UW column?

Paul Newcome

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.

Mathieu PERSICO

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,

Erika Haskell

Try this...<\/p>

=SUMIF(UW2:UW55, FIND("Kara Mylerberg", @cell) > 0<\/strong>, [Meeting Length (minutes)]2:[Meeting Length (minutes)]41)<\/p>

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.<\/p>","bodyRaw":"[{\"insert\":\"Try this...\\n=SUMIF(UW2:UW55, \"},{\"attributes\":{\"bold\":true},\"insert\":\"FIND(\\\"Kara Mylerberg\\\", @cell) > 0\"},{\"insert\":\", [Meeting Length (minutes)]2:[Meeting Length (minutes)]41)\\n\\nYou 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.\\n\"}]","format":"rich","dateInserted":"2020-08-05T15:40:38+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/258826#Comment_258826","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/258826#Comment_258826

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?

Erika Haskell

Hi Erika,<\/p>

I think the problem here comes from the difference of rows between your UW and Meeting Length ranges.<\/p>

Try this :<\/p>

=SUMIF(UW2:UW41, "Kara Mylerberg", [Meeting Length (minutes)]2:[Meeting Length (minutes)]41)<\/p>

or that:<\/p>

=SUMIF(UW:UW, "Kara Mylerberg", [Meeting Length (minutes)]:[Meeting Length (minutes)])<\/p>

Have a good day,<\/p>","bodyRaw":"[{\"insert\":\"Hi Erika,\\nI think the problem here comes from the difference of rows between your UW and Meeting Length ranges.\\nTry this :\\n=SUMIF(UW2:UW41, \\\"Kara Mylerberg\\\", [Meeting Length (minutes)]2:[Meeting Length (minutes)]41)\\nor that:\\n=SUMIF(UW:UW, \\\"Kara Mylerberg\\\", [Meeting Length (minutes)]:[Meeting Length (minutes)])\\nHave a good day,\\n\"}]","format":"rich","dateInserted":"2020-08-05T15:43:52+00:00","insertUser":{"userID":124372,"name":"Mathieu PERSICO","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mathieu%20PERSICO","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/JL9RVWFGDJGG\/nEXC7GUEA748S.jpg","dateLastActive":"2022-10-12T17:19:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/258828#Comment_258828","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/258828#Comment_258828

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!

Paul Newcome

Is that error anywhere within the UW column?

Erika Haskell

@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!

Paul Newcome

That was going to be my next question. Glad you figured it out and happy to help.️