Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

[Kevalson]

We'll start there in the subject.
I have been racking my brains.

In a row, you have a persons name.
I want next to that name how many GREEN cells are on that row that he is on.
He is on A4.
The data range for his name is from L4 to NL4.
Come cells have an orange, others yellow. Just want the green one summed up for now.

So for instance is he has 8 green cells in that range.
I would like it to display 8 in D4.

Confusing enough?

No VBA unfortunately.

My best to you all...

Kevalson

 

[Fluff]

Can that data be used to decide if the cell should be green?
For instance do you put a "H" in the cell if they are on holiday