Sumif Formula Question

PPonners

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.

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.