Problem with IF function....
 

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 email advice at where I work. The advisor will fill in a received time, start time and response sent time (column I). Then there is column J which specifies the name of the advisor. I am counting the date and advisor to show how many emails each advisor has done.
Now this formula does work, but will not work when using the input format of 'dd/mm/yyyy hh:mm'. I'm assuming it's because the IF is just looking for dd/mm/yyyy. Is there anyway in which i can ask the IF to disregard the hh:mm part in column I?

Hope that makes sense, thanks in advance.

Neil

Problem with IF function....
 

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
--
Mladen
http://excelancije.bloger.hr


On Mar 26, 9:15 pm, neilcarden
wrote:
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="Da*nielle",Apr07!$I $10:$I$1001)))}

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

Hope that makes sense, thanks in advance.

Neil

--
neilcarden

Thanks man!!! Much appreciated.