Hi,

Try this =sumproduct((range1=date(2009,7,25))*(range2="Dail y Telegraph"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"darbs" wrote in message
...
sorry it is a date

"Don Guillett" wrote:

Is your 25 Jul really a date or TEXT???
You failed to tell us.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"darbs" wrote in message
...
Tried both of these and its just returning 0

"Don Guillett" wrote:

Assuming your 25 Jul is TEXT

=sumproduct((a2:a22="25 July")*(j2:j22="daily telegraph"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"darbs" wrote in message
...
I need to count the number of rows which have a particular date in
column A
and then a particular name in column J, I have tried countif formula
but
can
not get it to work. Basically i need to count all the rows that
contain
the
"Daily Telegraph" in column J as well as containing say "25 JUL" IN
COLUMN
A,
any ideas?