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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the columns from one sheet and paste it in another sheet 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Conditional Counting 7
Countif(and 7
convert [h]:mm:ss to real number that I can use as a multiplier 3
How to Populate Data from a table to another 0
Counting values in column B in condition of A 2
Counting text cells then multiplying by a value in another column 6

Back
Top