Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
Thanks man!!! Much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function problem | Excel Discussion (Misc queries) | |||
Problem with IF function | Excel Discussion (Misc queries) | |||
Problem with IF function | Excel Worksheet Functions | |||
Problem with the VALUE function | Excel Discussion (Misc queries) | |||
FV Function Problem | Excel Worksheet Functions |