NB.IF color criteria Solved

Question

Hello,

I want to count the number of cells based on the background color of the cells. I think I will use the COUNTIF function, but I don't know what to put as criteria.

Thank you in advance for your help.

Mike-31 · Accepted Answer

Re,

I have to step out, but if you're following, we can do it by formula but it requires a bit of trickery
On your table, activate cell L3 and go to Insert/Name/Define
in the name in the workbook, enter for example color
in Refers to, paste this formula

=GET.CELL(38,numbering!D3)+(RAND()>1)
and OK
while your cell L3 is still activated, in the formula bar enter
=color
and drag down to the bottom of your table
to count the yellow cells in a cell, enter this formula

=COUNTIF(L3:L585,36)

for the beige-orange
=COUNTIF(L3:L585,40)
and for the gray
=COUNTIF(L3:L585,15)
A+
Mike-31

A period of failure is the perfect time to sow the seeds of knowledge.

Raymond PENTIER · Answer

Hello.

COUNTIF cannot read the color of a cell.
Therefore, you need to add codes in a column, and these codes will trigger the display of colors in your cells, thanks to Conditional Formatting rules; these codes will also allow you to write a formula with COUNTIF.
Send your file using https://www.cjoint.com/

--
Retirement is nice! Especially in the West Indies... :-)
☻ Raymond ♂

g · Answer

Hello,

It's possible, but you first need to go through VBA to define the color numbers, and then apply COUNTIF to those numbers.
For the VBA code, see http://gerard.g.pagesperso-orange.fr/logexl_05.htm#Numero_couleur_cellule

Best regards.

Mike-31 · Answer

Hi,

Nothing prevents you from quickly creating a file of a few anonymized lines; you wouldn't want us to do it for you, or for us to send you the invoice.

See you,
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

albelo03 · Answer

Here is the link https://www.cjoint.com/?3FejDrxKnBJ I want to count the number of cells by color in column D.  Thank you for your help.

Mike-31 · Answer

Re,  Yes, but you don’t mention how you color your cells manually or with conditional formatting?  See you later Mike-31  A period of failure is a perfect time to sow the seeds of knowledge.

Mike-31 · Answer

Re,  well do you know how to create an ActiveX button and go into Visual Basic  -- A+ Mike-31  A period of failure is a perfect time to sow the seeds of knowledge.

Mike-31 · Answer

Hi,

it's not going to be easy. If you have Excel 2007 or 2010, do you have the Developer tab on your Ribbon? It's to the right of the Review and View tabs.

--
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Mike-31 · Answer

Re,

If you use the basic colors from the Excel palette, we can achieve that with a formula; can you change your colors?

--
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Mike-31 · Answer

Re,

It's one of the few solutions without VBA, the only downside is using basic colors and knowing the color index.

--
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

NB.IF color criteria

10 answers

System restore from bootable windows 11 usb drive

Ink cartridge replacement

Discount card

Several computer components

Samsung wallet

Texture issues in enshrouded

Landscaper invoicing and quoting software

The cart does not move in order to change a cartridge.

Youtube music

Transfer data to a new pc