Hi Max
I am unable to do this if i use the Formula u have give its giving the Value
N/A
Here is the exact sheet format
A B C D E
F G H
31490 XXXX XXXX XXX XXXX Review XXXX December 9, 2008 05:00 PM GMT+01:00

I have placed all the data in the Sheet named Requests. Now i want to pull
the data to Summary Sheet with the Count total incidents which are in review
Status (Colmun F) which are logged on December 9(Column H)

Please do helpme to resolve



"Max" wrote:

.. 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