Hi
try
=SUMPRDUCT(--(E1:E1000="Acorn"),--(V1:V1000<""))

For more about SUMPRODUCT see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Jako " schrieb im Newsbeitrag
...
Can anyone please tell me how i can count the number of rows on
worksheet "Raw" that contain the text "Acorn" in column "E" but only
if
the cell in column "V" is not empty.

Also i would like to copy the row that meets the above criteria to a
new worksheet called "Checked"

TIA


---
Message posted from http://www.ExcelForum.com/