Counting the number of Guests to be In House on a certain day.

**JJohnsey** · 02-23-2013, 01:40 PM

Hey Everyone - hope someone can help.

I am trying to count the number of workers that will be checked in on a given day.
I have a spreadsheet with two sheets that shows the check in and out dates and I need to know how many will be in on each day.

SHEET 1
A1 A2 A3
1 WORKER CHECK IN CHECK OUT
2 NAME JAN 13-2013 FEB 13-2013
_________________________________________
SHEET 2
A1 A2
1 DATE #CHECKED IN
2 JAN 18-2013 ?????

So I have to count how many workers are checked in on any given day; such as Jan 18-2013 I want to know how many workers will be checked in.

**oeldere** · 02-23-2013, 02:06 PM

You can do that with pivot table.

If you add an excel file without confidentional information and the desired (expected) result, i will add the pivot table in your file.

**dredwolf** · 02-23-2013, 02:12 PM

you could use something like this:
=COUNTIFS('Sheet 1'!$B$2:$B$1000,"<="&A2,'Sheet 1'!$C$2:$C$1000,">="&A2)

Hope this helps

**JJohnsey** · 02-23-2013, 02:23 PM

Copy of Tracking.xlsx

Here is the spreadsheet. I want to find out the TOTAL # Workers In House on Sheet 'Head Count' from the table 'Tracking'

**oeldere** · 02-23-2013, 02:31 PM

The solution of dredwolf is better for this question than an pivot table. (i suppose).

So I added his (dredwolf) formula in your sheet.

See the attached file.