Try

=SUMPRODUCT(--(Sheet1!B2:B200=--"2010-02-05"),--(Sheet1!B2:B200<=--"2010-2--10"),
--(Sheet1!O2:O200="Audio / Telephony / VOIP"),--(Sheet1!P2:P200="Audio
Broadcasting"),
Sheet1!Q2:Q200="Quality")

--

HTH

Bob

"Sasikiran" wrote in message
...
The date range in the formula is not allowing me to get the desired figure

(Sheet1!B:B="2/5/2010 0:00:00 AM")*(Sheet1!B:B<="2/10/2010 11:59:59 PM")

Please suggest


"Eduardo" wrote:

Hi,
try

=SUMPRODUCT((Sheet1!B:B="2/5/2010 0:00:00 AM")*(Sheet1!B:B<="2/10/2010
11:59:59 PM")*(Sheet1!O:O="Audio / Telephony /
VOIP")*(Sheet1!P:P="Audio Broadcasting")*(Sheet1!Q:Q="Quality"))

"Sasikiran" wrote:

Dear,

I am trying to work on a formula which gives the count within a date
range
with few specifications in some of the columns.

The data is in Sheet1 and I want to insert the formula in Sheet2.

From the raw data, I would like to get a formula which calculates the
number
of times the specified categories are present in these columns.

The date is in m/d/yyyy h:mm format.

Within the specified date range in column B, the formula should search
for
"Audio / Telephony / VOIP" in column O, "Audio Broadcasting" in column
P,
"Quality" in column Q and gives the count if all the criteria is
matched.

Please help

=SUMPRODUCT((Sheet1!B:B=--"2/5/2010 0:00:00 AM"),
(Sheet1!B:B<=--"2/10/2010 11:59:59 PM"), (Sheet1!O:O=--"Audio /
Telephony /
VOIP"), (Sheet1!P:P=--"Audio Broadcasting"), (Sheet1!Q:Q=--"Quality"))