Count the occurance of a value x a value in another cell in excel

B

Batty

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?
 
K

KL

Hi Batty,

Is this what you are after (?):

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

Regards,
KL
 
Top