Excel 2010 countifs for date range

[puck1263]

Hell
I searched through the countifs threads and didn't find exactly what I'
looking for

I've attached my excel file as a Zip file

What I want to do is, on the Analysis worksheet in cell C7, I want
count of how many cells in the Raw Data worksheet Column E, have a dat
that is equal to the date in B7 AND less than B8. Basically, how man
count during the week
If the formula is working, based on what is in the raw data worksheet
C7 should return 8. If copied down to C8, it should return 2

I've tried using various COUNTIFS, some return an error and some retur
a zero (wrong...

I'd like to copy it down the column for a count each week
I'd like to repeat this for other columns also (counting in adjacen
columns in raw worksheet

+-------------------------------------------------------------------
|Filename: FTC EC Tracking.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=732
+-------------------------------------------------------------------

 

[Spencer101]

Hello
I searched through the countifs threads and didn't find exactly what I'
looking for.

I've attached my excel file as a Zip file.

What I want to do is, on the Analysis worksheet in cell C7, I want
count of how many cells in the Raw Data worksheet Column E, have a dat
that is equal to the date in B7 AND less than B8. Basically, how man
count during the week.
If the formula is working, based on what is in the raw data worksheet
C7 should return 8. If copied down to C8, it should return 2.

I've tried using various COUNTIFS, some return an error and some retur
a zero (wrong...)

I'd like to copy it down the column for a count each week.
I'd like to repeat this for other columns also (counting in adjacen
columns in raw worksheet)

Put the below in C7 and copy down

=COUNTIFS('EC Status Report - Raw Data'!E:E,">="&B7,'EC Status Report
Raw Data'!E:E,"<"&B8

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[puck1263]

Thanks!
puck126

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

Thanks!
puck1263

No worries. Glad to help :

+-------------------------------------------------------------------
+-------------------------------------------------------------------