One cell based on whether 10 out of 12 other cells is green?-CodePudding

Home > Enterprise > One cell based on whether 10 out of 12 other cells is green?

One cell based on whether 10 out of 12 other cells is green?

Time：09-26

I'm trying to track my school attendance with Google Sheets. I need any 10 attendances out of 12, and I want to show in one cell whether I meet that criteria. Is there a way to format that, aka 10 out of the 12 previous cells in a column is green/has "yes" etc.?

CodePudding user response：

Use this formula

=COUNTIF(B2:B13, "=Yes")&"/"&COUNTA(B2:B13)

Or this

=IF(COUNTIF(B2:B13, "=Yes")>=10,"Criteria met", "Criteria not met")

Page link：https//www.codepudding.com/Enterprise/554965.html

Prev:Move filtered array to another sheet using Google Apps Script

Next:List Google drive folder contents to google sheets with only new files

Tags：

google-sheetsformatting

Links：
CodePudding