Counting A Range of RYG Balls at Once

I have researched and tried the various formulas for counting the RYG balls in one column from 1 row through 540. I have tried various formulas but I keep receiving and error. Can someone help me by letting me know what I am doing wrong? Here are few formulas I have tried.

=COUNTIF(CHILDREN([Status of Completion]1:Status of Completion]540), "Red")

=COUNTIF(CHILDREN(Status of Completion), "Red")

I've tried this one, I found on the community group site as well.

=IF((COUNT(CHILDREN(Complete1)) = (COUNTIF(CHILDREN(Complete1), 1))), "Green", IF(COUNTIF(CHILDREN(Complete1), 1) = 0, "Red", "Yellow"))

=IF(AND([Column2]1 = 1, [Column3]1 = 0), "Green", IF(AND([Column2]1 = 0, [Column3]1 = 1), "Red"))

Nothing seems to be working. It keeps saying #UNPARSEABLE

Please Help!

Thanks!

Find more posts tagged with

Education

Formulas

Support

Comments

Mitch.Shaffer

Give this formula a try and let me know if that works for you:

="Green: " + COUNTIF([Status of Completion]:[Status of Completion], "Green") + " Yellow: " + COUNTIF([Status of Completion]:[Status of Completion], "Yellow") + " Red: " + COUNTIF([Status of Completion]:[Status of Completion], "Red")

cme14041

ABSOLUTELY! THANK YOU SOOOOO VERY MUCH!

Mitch.Shaffer

You're welcome! I used [Status of Completion]:[Status of Completion] to count everything in the column rather than using CHILDREN(). Makes it a little easier to manage.