Hello, can someone please help with a formula?

Jessica Ochoa

I am trying to build a formula based on if the drop down of one column (Event Type = Pop Up) is completed based on another column (Completed = True).

I have this formula to count the number of events that are Pop Ups, but I cannot figured out how to add up which of these is complete. I appreciate your help!

=COUNTIF([Event Type]:[Event Type], "Pop Up")

DKazatsky2

Hi @Jessica Ochoa,

Is the "Completed" column a text value or a checkbox?

Here is the formula for text:

=COUNTIFS([Event Type]:[Event Type], "Pop Up", Completed:Completed, "True")

Here is the formula for checkbox:

=COUNTIFS([Event Type]:[Event Type], "Pop Up", Completed:Completed, 1)

Hope this helps,

Dave

Jessica Ochoa

Thank you so much Dave, this worked! Appreciate your help!