Forum Discussion
Solved
Having trouble counting cells by fill color.
I have been trying to find an easier way to calculate the number of cells from column B through column F by color rather than needing to do it manually for each sheet. For example, I want the H4 cell...
=COUNTIF($B$1:$B$152,">=90")
=COUNTIFS($B$1:$B$152,">=80",$B$1:$B$152,"<90")
etc. Modify the ranges as needed.
=COUNTIF($B$1:$B$152,">=90")
=COUNTIFS($B$1:$B$152,">=80",$B$1:$B$152,"<90")
etc. Modify the ranges as needed.
- The second one is working after changing the second set of Bs to Fs so it calculates for all the columns (I might not have explained that well enough). Thank you very much for the solution!
