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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count the occurance of a value x a value in another cell in excel (https://www.excelbanter.com/excel-worksheet-functions/35552-count-occurance-value-x-value-another-cell-excel.html)

Batty

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

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?

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?

All times are GMT +1. The time now is 03:46 AM.