I am trying to use countifs function in google sheets to count colored cells in one column, but only if the colored cell meets the value I set in a separate column in the same row. In my head, the formula would be something like: =Countifs(I:I, "Tuesday", P:P, "light green")
I am already using the "countcoloredcells" script, but can't seem to modify it (if that's possible) to add the additional variable. Help!
I am already using the "countcoloredcells" script, but can't seem to modify it (if that's possible) to add the additional variable. Help!