.. the no.of incidents which are in review status logged on December 9

Try something like this, normal ENTER:
=SUMPRODUCT((C2:C100="Review")*(TEXT(D2:D100,"ddmm myyyy")="09Dec2008"))

The above presumes data in col D (date logged) is cleaned up as real dates

With col D "as-is", you could try:
=SUMPRODUCT((C2:C100="Review")*(TEXT(SUBSTITUTE(D2 :D100,"GMT",""),"ddmmmyyyy")="09Dec2008"))
which removes the "GMT"


or perhaps even:
=SUMPRODUCT((C2:C100="Review")*(TEXT(SUBSTITUTE(D2 :D100,CHAR(10)&"GMT",""),"ddmmmyyyy")="09Dec2008") )
which removes both the preceding hard return & "GMT"

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Raj" wrote:
Here is the excel data how my data is distributed.

Incident Description Status Date logged
313 XXXXX Review December 9, 2008 2:16 PM
GMT

There are thousands incidents with different status looged in these year.
Now i would like to See the no.of incidents which are in review status
logged on December 9. Can you please suggest me an array extract this data