Sumif Formula Question

I have a sheet containing a Time Block column as well as a Type column. Both are dropdown columns one with time in hours (.24, .5, .75, 1, 2 and so on), the other has types of activities (Dev Meeting, General Admin, and so on). I am trying to build a formula that adds the time for each activity by the month. I can't get past adding up the time by activity. Right now I am doing it in as part of the Sheet Summary. My formula is: =SUMIF(TimeBlock:TimeBlock, ={Dev Meeting}, Type:Type) I get a total of zero, indicating the formula is correct, but I know there are several entries of Dev Meeting types equaling several hours. Any help is appreciated.

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

Andrée Starå

Hi @PPonners

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PPonners

@Andrée Starå

Thank you for responding. I took a screen shot of my column headings and one of the formula I am trying to create. Thank you for an any assistance you can provide.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.