Countif - Selecting a date range only counts blank cells and not populated cells

Hi there,

Arrggghh - this formula is making me lose hair - can anybody please help??

Along row 1, I have employee names, Bill, Ben, Ted etc and down collumn A, I have dates 1/1/11, 2/1/11, 3/1/11 etc. When an employee is off sick I want to place a letter 'S' in the correct cell which will show who and when an employee is off sick.

On a seperate sheet I have the names running down the collumn and two cells to select a date range which will tell me how many times that person has been off by reading off the big table

Currently I have this formula as an array

=COUNT(IF((HW!$A$2:$A$1108>=Comparision!$C$3)*(HW!$A$2:$A$1108<=Comparision!$D$3)*(B10=HW!D4),HW!D13:D1108,"S"))

A13:A1108 are the dates
$C$3 is the from date range on the seperate sheet
$D$3 is where I want to enter the to date
B10 is the name looking up against the same name in HW!D4

At the moment it seems to be reading blank cells and not cells marked "S"

Does anybody know a fix???????????

Thanks
Pete

Could you post an example workbook, please?

That works perfectly - Thanks alot!!!!!!!!!!!