Excel - Countif by Cell Value AND Cell Color

[canuck_moose]

I am helping to manage a local rec soccer league. I have a sheet in Excel for each team. On the sheet are the names of all of the other teams in a column. I want to record wins & losses, and then use cell color to indicate if it was a home or away game. I will use a W in the cell for a win and an L in the cell for a loss. My goal is to have a total win/loss calculation which is easy. I'd also like to have a Win/Loss calculation based on the cell color for Home/Away games. Is it possible to do a function that basically says countif the cell value in a range is "W" and the cell background color is Blue?

 

[awoohaw]

There is no function to count cell colors. If you have conditional formatting (CF) rules to set the color format, then use the same rules as the CF in your counting.