Sheet Summary Formula to count check box

Melanie Sanders

Hello, I am having a hard time setting up this formula in Sheet Summary

=COUNTIF([Account is Ready]:[Account is Ready], "ischecked")

Can you help.

Vince Darrigo

Hi @Melanie Sanders I think you just need to replace that ischecked with a 1:

=COUNTIF([Account Is Ready]:[Account Is Ready], 1)

I hope this helps!

Peggy Parchert

Hello @Melanie Sanders

try this:

=COUNTIF([Account is Ready]:[Account is Ready], 1)

Hope it helps.

Peggy

Vince Darrigo

Hi @Melanie Sanders I think you just need to replace that ischecked with a 1:

=COUNTIF([Account Is Ready]:[Account Is Ready], 1)

I hope this helps!