counting information in one column based on criteria in another co

L

lost in excel

Have a list of states in one column and I want to count how many times a
value appears in another column. My example is this I have a range of
numbers in column c from 1 to 10. Based on the value in column a (state
abbrv) I need to count the number of times the number 6 appears.
 
T

T. Valko

Try something like this...

To count for state New York and 6:

=SUMPRODUCT(--(A1:A100="NY"),--(C1:C100=6))
 
L

lost in excel

It worked like a charm! Thanks for the help!

T. Valko said:
Try something like this...

To count for state New York and 6:

=SUMPRODUCT(--(A1:A100="NY"),--(C1:C100=6))

--
Biff
Microsoft Excel MVP





.
Click to expand...
 

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
Formula - count Nº of entries but with other filtering criteria 2
Excel How to count from a column if specific condition in another column is true 3
format cells in one column based on value in another column 3
Counting with Date Range as Criteria 5
Excel Subtracting multiple columns from another column 3
Counting with two criteria where one is between values 1
list choice depending on the value in another cell 1

Top