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

Erika Haskell · 08/05/20

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 · 08/05/20

Is that error anywhere within the UW column?

Paul Newcome · 08/05/20

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 · 08/05/20

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 · 08/05/20

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 · 08/05/20

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 · 08/05/20

Is that error anywhere within the UW column?

Erika Haskell · 08/05/20

@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 · 08/05/20

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

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

Best Answer

Answers

Help Article Resources

Categories