"COUNTA" but EXCLUDE cells with a "fill" of color

[RoseBrooke]

I want to create a formula that counts all nonblank cells in a column. BUT, I want to exclude any nonblank cells that ARE filled with a color from being counted. How can I do this?

 

[Asala42]

Formulas can't directly evaluate based on colors, but you can with some vba. Of course if there's some other logic causing these colors you could potentially use that logic instead of resorting to vba

Here's a thread that may assist from this board.
http://www.mrexcel.com/forum/excel-questions/596605-count-cells-based-fill-color-text-criteria.html

 

[RoseBrooke]

Formulas can't directly evaluate based on colors, but you can with some vba. Of course if there's some other logic causing these colors you could potentially use that logic instead of resorting to vba

Here's a thread that may assist from this board.
http://www.mrexcel.com/forum/excel-questions/596605-count-cells-based-fill-color-text-criteria.html

I have no idea what a VBA is, and I am afraid I have little time to find out.
As for why the colors are there, it is because I add colors to cells containing values which are in the past and no longer relevant in the future (in the context of my spreadsheet), making it easier for me to see currently relevant values. I want a box/cell at the top of each column to automatically update/count the non-colored cells in the column that have text in them. So, when I fill in a particular cell/box with a color, the total amount of non-colored boxed with text are automatically updated.

 

[Asala42]

Instead of using the colors as the logical condition, it sounds like you could get away with counting date entries in the past. For example:

=COUNTIF($A$5:$A$100,"<"&TODAY())

Where A5:A100 contain date entries. This would count date entries that are now past due (yesterday or prior)