COUNTIF Checkbox Marked and Then COUNT Product

Amanda Chu

There is a column called "Terminated" and it is a checkbox and 5 other columns with Product1, Product2, Product3, Product4, and Product5 which are also checkboxes. 

I need a formula to COUNTIF "Terminated" is Checked, then COUNT the Product1, Product2, Product3, Product4, and Product5 columns. 

For Example: 

Terminated = Checked

• Product1 = Checked
• Product3 = Checked
• Product5 = Checked

Paul Newcome

Try something like

 

=COUNTIFS(Terminated:Terminated, 1, [Product1]:[Product1], 1)

Amanda Chu

Thank you! This works beautifully! 

Paul Newcome

Happy to help.