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

Options

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:

• ✭✭✭✭✭✭
Options

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.

• Options

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

• Options

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?

• Options

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!

• Options

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

• ✭✭✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!