count by color

  1. J

    Count receipts using cell colour

    Hello, I'm currently working for a company selling phone cases and other accessories and, even tho they don't really care about their own Excel files, I do, as it makes the workflow much more convenient. Recently, my manager has asked me if I could come up with a formula for automatically...
  2. S

    Counting a sign up list & if paid

    Hi Everybody! I have a list of names for an event people need to sign up & pay for. In an Ideal world, I would like excel to count if somebody is on the list, and also if they have paid. Right now I'm sorting this by text color and manually counting. I'm not sure if I need to create Macro...
  3. T

    Count conditional formatting color

    Hi all, thanks for your help in advance, I've been struggling to find something that fits my need. I have a table of KPI measurements for a number of people/ locations within tables that are conditionally formatted based upon the criteria. I want to be able to count how many people/locations...
  4. L

    Sum or count cells where the background color matches a color in a range of cells

    I'm using an updated version of a UDF I found years ago on Ozgrid's website and I've seen many versions of this over the years and through many searches. The UDF allows you to sum or count cells where the background color matched a reference cell's color. A few years ago I updated the code to...

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