IF function....

Originally Posted by 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 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

Hi,

one way is to test >= today and < tomorrow, of the format

=COUNT(IF(Sheet1!$H$2:$H$4>=VALUE("27/3/2007"),IF(Sheet1!$H$2:$H$4<VALUE("28/3/2007"),IF(Sheet1!$I$2:$I$4="red",Sheet1!$G$2:$G$4))))

hth
---

Originally Posted by neilcarden

Yes!!!

Thanks Bryan, I didn't think of putting a less than IF value in, as long formulae freak me out.... but yes that works fine!

Thank you.

good to see it works for you, and thanks for the feedback.
---