Improve company productivity with a Business Account.Sign Up

x
?
Solved

excel counting

Posted on 2013-11-20
3
Medium Priority
?
216 Views
Last Modified: 2014-04-02
Hi,

How do I look up value from column A in column C and count the value in column D. Please see my attached example.

Thank you in advance.
counting.xlsx
0
Comment
Question by:chekn3
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Tony Barkdull earned 2000 total points
ID: 39664419
Try this. I put the result in column B

=COUNTIF($D$1:$D$14,(LOOKUP(A1,$C$1:$C$14,$D$1:$D$14)))
0
 

Author Comment

by:chekn3
ID: 39664470
Works perfect. Thank you.
0
 

Author Comment

by:chekn3
ID: 39973773
I've requested that this question be closed as follows:

Accepted answer: 0 points for chekn3's comment #a39664470

for the following reason:

Problem solved
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

605 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question