We help IT Professionals succeed at work.

excel, how do we count how many same values exist in Column D

motioneye
motioneye asked
on
I have excel sheet from colum A - G, I would like to know how do I find how many same values exist in column D
Comment
Watch Question

You can use
=COUNTIF ( Range, Criteria)

For example,
=COUNTIF(D:D,D1) -> it will give you the number of times the D1 values exists in D column.

If the above is not helpful, please provide example for your request
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
If you mean how may distinct values:

=SUMPRODUCT(1/COUNTIF(D1:D100,D1:D100&""))

adjust the ranges as required.
IT Consultant
Commented:
use pivot table where you can see count of each value
check my example for oyu in attachment (imagine my column "Gender" is yours G)
sample.xlsx

Explore More ContentExplore courses, solutions, and other research materials related to this topic.