Opps, too many "0" in the 2nd part of the formula, use

=COUNTIF(J1:J100,"Daily Telegraph")+COUNTIF(A1:A100,"25 JUL")


"Eduardo" wrote:

Hi,

=COUNTIF(J1:J100,"Daily Telegraph")+COUNTIF(A1:A1000,"25 JUL")

"darbs" wrote:

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?