Hi Batty,

Is this what you are after (?):

=COUNTIF(Sheet2!$1:$65536,"X")*Sheet1!A1

Regards,
KL


"Batty" wrote in message
...
How do I count the number of times a value appears on a spread sheet and
multiply that number by a value in another column?