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]

How are the cells getting their colour?
Manually, or via conditional formatting?

 

[Joe4]

Take a look here: https://trumpexcel.com/count-colored-cells-in-excel/

Also, if the cells are colored by Conditional Formatting, you should be able to use the same conditions used in Conditional Formatting in COUNTIF, COUNTIFS, or SUMPRODUCT formulas to get the counts.

 

[Kevalson]

Manually
And it needs to count on the row., not column.
So how many green cells are from L4 through NL4 for instance.

 

[Fluff]

You could use the Get.Cell approach
In the Name manager select "New" give it a name (I've used IsColoured) and enter this formula
=GET.CELL(63,INDIRECT("rc[-365]",FALSE))
Then in column NM put =IsColoured and fill right to column ABM
You than then use a countif to count those cells.

However changing a colour will not force a recalculation so you will have to do that yourself. It is also likely make your workbook a lot larger & possibly slower.

 

[Marcelo Branco]

Manually

What is the criterion (logic) that is used to manually color cells green? Greater than a certain value? Does it contain some keyword? Or any other criteria (?)
I believe they are not randomly colored, or are they?

M.

 

[Kevalson]

no not randomly.

It's a calendar that is someone takes a day off with pay, we manually turn that cell green on that particular date.

 

[Marcelo Branco]

no not randomly.

It's a calendar that is someone takes a day off with pay, we manually turn that cell green on that particular date.

Then you should use the solution suggested above by Fluff or VBA. Unfortunately, as far as I know, a formula can't identify a colored cell.

M.

 

[Fluff]

Are the cells empty?

 

[Kevalson]

No. They have some data in them.