Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

excel counting

Posted on 2013-11-20
3
Medium Priority
?
202 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

916 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