Problem with IF function....

[neilcarden]

Hi, I am using a COUNT combined with 2 IF functions, as shown...

{=COUNT(IF(Apr07!$I$10:$I$1001=VALUE("1/4/2007"),IF(Apr07!$J$10:$J$1001="Danielle",Apr07!$I$10:$I$1001)))}

To give you the overview, it's a spreadsheet for time recording emai
advice at where I work. The advisor will fill in a received time, star
time and response sent time (column I). Then there is column J whic
specifies the name of the advisor. I am counting the date and adviso
to show how many emails each advisor has done.
Now this formula does work, but will not work when using the inpu
format of 'dd/mm/yyyy hh:mm'. I'm assuming it's because the IF is jus
looking for dd/mm/yyyy. Is there anyway in which i can ask the IF t
disregard the hh:mm part in column I?

Hope that makes sense, thanks in advance.

Nei

 

[Mladen_Dj]

Use integers for date:

{=COUNT(IF(INT(Apr07!$I$10:$I$1001)=VALUE("1/4/2007"),IF(Apr07!$J$10:$J
$1001="Danielle",Apr07!$I$10:$I$1001)))}

Regards

 

[neilcarden]

Use integers for date:

{=COUNT(IF(INT(Apr07!$I$10:$I$1001)=VALUE("1/4/2007"),IF(Apr07!$J$10:$J
$1001="Danielle",Apr07!$I$10:$I$1001)))}

Regards

Thanks man!!! Much appreciated