You probably want...

=SumProduct(('Worksheet 2'!J2:J500="Joe Blow") * ('Worksheet 2'!
H2:H500="New"))

Check out this link for more info...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"A Newton" wrote:

I have a two-sheet workbook. On one sheet (Worksheet 1), I want to
count the total cells in the other worksheet that contain the words
"Joe Blow" in column J and the word "New" in column H. I was hacking
away trying something like this:

=COUNTIF('Worksheet 2'!J2:J500,"Joe Blow") AND ('Worksheet 2'!
H2:H500,"New")

But no dice. . .

Also, is there an easy way to say "all of column J" and "all of column
H" instead of using the range as I've done above. (I just said 500
'cuz it was well beyond the end of the data range.)

Thanks in advance for suggestions/help.

-- Adam