Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# excel counting

Posted on 2013-11-20
Medium Priority
191 Views
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.

counting.xlsx
0
Question by:chekn3
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 10

Accepted Solution

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

ID: 39664470
Works perfect. Thank you.
0

Author Comment

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

Question has a verified solution.

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

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
###### Suggested Courses
Course of the Month5 days, 11 hours left to enroll