Hello all!
I am sure the solution to this is very simple.
In a workbook, column F contains the initials of our team members. If that team member participated in Activity A, the cell containing their initials turns pink. If they participated in Activity B, the cell containing their initials turns teal.
In another sheet on the workbook, I need a formula to count the initials and the color.
This is what I was trying:
=CountCellsByColor('L1 TM'!$F$24:$F$5000,B25) & IF('L1 TM'!$F$24:$F$5000,"ABC")
B25 is the cell where the color is as a reference.
But the formula doesn't work. Can anyone help me out??
Thank you!
Bookmarks