Counting option

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

Guest

Hi,

I have a bit of a problem when counting values, for example on sheet 2 in
the A colum you are allowed to select a value from a drop down, what I want
on sheet 1 is to be able to count the number of each of these options e.g.

A
 
In Sheet1,
Assume you have listed the DV options in A1 down,
eg: A,B,C,D, ...

Then just place in B1:
=COUNTIF(Sheet2!A:A,A1)
Copy B1 down
 

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

Counting Values 1
How to Populate Data from a table to another 0
COUNTIF + ADDRESS Issue 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
About references 1
Count the columns from one sheet and paste it in another sheet 0
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top