How to count only the not colored cel's

[Aldifi]

Hi all,

I need to make an excelfile where I can count the number of "G" in a area.
Also all the cells that have a background color, should not be counted.

For example:
A1 = F (no background color)
A2 = F (background color red or blue)
A3 = F (no background color)

I need a formula that gives me the number of F's with no background color, in this case 2.
Something like countif(A1:A3;"F")

Can someone please help ?

Thank you !

[JoeMo]

Try this:

Please Login or Register  to view this content.