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

New Member
Joined
Apr 16, 2002
Messages
22
Office Version
  1. 2013
Platform
  1. Windows
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
 
Last edited:

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
How are the cells getting their colour?
Manually, or via conditional formatting?
 
Upvote 0
Manually
And it needs to count on the row., not column.
So how many green cells are from L4 through NL4 for instance.
 
Last edited:
Upvote 0
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.
 
Upvote 0

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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
Are the cells empty?
 
Upvote 0

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top