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?