Hi,

=SUMPRODUCT(--(J1:J100="Daily Telegraph"),--(A1:A100=date(2009,7,25)))

"darbs" wrote:

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?