Count number of occurrences and return value

**JanJHL** · 03-28-2019, 10:32 AM

Hi All,

I have a Lead sheet, where I type in Hot and cold leads, tagging them red or green.
In the bottom of the sheet I want to do a sum of the values from a range of the red cells, for instance A1:A120

1. Find out what cells are red
2. Do a SUM of the values of all red cells in a specific column range

I have the VBA formula for checking the color in the cell, but I cannot figure out how to SUM the value of a range of "found" cells.

I thought about vlookup or Countif, but so far did not solve this.

Anybody with the magic beans, that can help?

Kind regards...Jan

**Special-K** · 03-28-2019, 11:08 AM

Formulas cant detect the color of a cell (unless its conditional formatting, in which case use the same conditions) so youre only hope is VBA.

Set a variable to 0.
Loop through the column.
If the cell colour is what you want increment the variable
At the end of the loop the variable will contain the number of cell colours you checked for.

or use the VBA to set 1 flag 1 or 0 in a Helper column and just use SUM() for that column.

Count number of occurrences and return value

LinkBack

Thread Tools

Rate This Thread

Display

Count number of occurrences and return value

Re: Count number of occurrences and return value

Thread Information

Users Browsing this Thread

Similar Threads

Count number of occurrences and return in text

Count number of occurrences

[SOLVED] Count number of occurrences but if there are consecutive matches count them as one

Count number of occurrences in a day

[SOLVED] Count number of occurrences for a number of ranges from a find loop

[SOLVED] Count number of occurrences

Count Number of Occurrences in a Column

Bookmarks

Bookmarks

Posting Permissions