Sum letter and his value
Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …
How to highlight four cells a number of cells away from a reference cell
Hi, Is it possible to highlight cells a specified number of cells away from a reference cell? the specified number of cells away would be the value …
Counting within Polygons
I have an excel map two layers. One layer contains points (defined by longitude and latitude) and another layer containing polygons (shapefile format). Is …
Count With Criteria
Hi, Please how to I count the number of yes in coloumn are the match dog or car in column b? By:
Alternating TRUE & FALSE values – Count
I have a list of data, exported to excel, which has ‘TRUE’ or ‘FALSE’ in a column, based on if they checked a box on a previous form. …
Count color backgrounds
Greetings, I got a question about a function. My skills in VBA isn’t that great, so sorry. But, what I want is a function that will check e.g. cell L5 …