Sheet Summary Formula HELP
Hello I am looking for some help with a couple of formulas in sheet summary. The first would be the best formula to use for a dropdown Yes or No column that I need to count if either is chosen? I have it where it will count if Yes but coundn't figure out how to add the No as well.
=COUNTIF([CONVERT TO PLASTIC PIG]:[CONVERT TO PLASTIC PIG], "YES")
Second formula would be for a column with a checkbox. I need to be able to count if checked and then also if not checked. I have tried to insert "yes" and also "true" in my formula but that doesn't seem to work.
=COUNTIF([ACCT READY TO RECEIVE PLASTIC PIG]:[ACCT READY TO RECEIVE PLASTIC PIG], "yes")
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!