Symbol Formula

Trevor Phelps

Good morning, I am inquiring about a formula that adds a quantity of certain symbols within a sheet.  I would like the total of check marks to be added. Attached is a screenshot of what I have unsuccessfully attempted thus far.  Please let me know what changes are needed.  Thank you

Andrée Starå

Hi Trevor,

If you want to count how many days that are "Yes" you don't need the ,1,0" at the end of the formula.

Try removing it, and it should work.

Try this instead, and you don't have to think about row numbers.

=COUNTIF(Monday@row:Sunday@row,"Yes")

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Trevor Phelps

Thank you for the prompt reply. This formula worked perfectly for me

Andrée Starå

Great!

Happy to help!

Best,

Andrée