## 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 …