Formula help with 2 columns of check boxes

Melissa V

Hi,

I am new to Smartsheet and need some help. The main column is [Customer Name] and all rows below it are different customer names. Next, I have two checkbox columns [Comp. A Ready] and [Comp. B Ready]. I have used COUNTIF formulas to total the number of checked boxes for [Comp. A Ready] and [Comp. B Ready] individually in sheet summary.

Next in Sheet Summary, and what I can't figure out, is how to obtain the number of customers who have [Comp. A Ready] checked and [Comp. B Ready] not checked.

Thanks!

jaimelynn0814FEB

Would this work? =COUNTIFS([Comp. A Ready]:[Comp. A Ready], 1, [Comp. B Ready]:[Comp. B Ready], 0)

This formula will give you the count of all rows where "[Comp. A Ready]" is checked and "[Comp. B Ready]" is not checked, effectively counting the number of customers meeting these conditions.

jaimelynn0814FEB

Would this work? =COUNTIFS([Comp. A Ready]:[Comp. A Ready], 1, [Comp. B Ready]:[Comp. B Ready], 0)

This formula will give you the count of all rows where "[Comp. A Ready]" is checked and "[Comp. B Ready]" is not checked, effectively counting the number of customers meeting these conditions.

Melissa V

It worked. THANK YOU! I was missing the comma after the "1" .