Home > other >  Google Sheets Script to count cells with color with several criteria
Google Sheets Script to count cells with color with several criteria

Time:06-06

In a google sheets table, I use a script that allows me to count the cells in color in a column that displays dates as values. Each date over 11 days is colored in red, and my script works very well.

In another column, I indicate the name of each salesman. What I would like is to be able to count the number of red cells that belong to each salesman.

The date column is column "G" and the salesman column is column "F" (In my script it doesn't matter because I indicate in which column to count).

My Sheet:

enter image description here

  • Related