Calculating a sum of certain data based on other dats
I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …
find, count, return title
I have a timetable for my school. In the first column are the staff. Across the rows are the days of the week. The content of the table is …
Basic Count Average Bar Chart
I have a Workbook with 9 SheetsEach Sheet has 4 columns of data:Column A: Login (Time Stamp of User login)Column B: User (Name)Column C: Team (Department …
Delete Duplicates
Ive got data sorted like this (see below), if I select column by column and then go “Delete duplicates” then it works fine, however if I select …
count occurrences of every calendar day within several date ranges
lets say i have : start date 1 and end date 1 , start date 2 and end date 2 , start date 3 and end date 3. I want to know how many times the date …
Count Multiple Values
Hi, I’m wondering if there is a way to use the Count function while assigning different values to different texts. More specifically, I’m trying to …
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 …