CountIF

[Patricia H]

I have a column of names that i need to count; however, I only want to count the total number of different names that appear. In other words, if james appears 5 times in my column, i only want him to count once. How would i set up the countif statement?


Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider
http://www.eggheadcafe.com/tutorial...dfe-9f7a28f4d58e/filebased-cache-for-web.aspx

 

[Bernard Liengme]

Here is the formula
=SUMPRODUCT(--(data<>""),1/COUNTIF(data,data&""))
replace 'data' by the range (such as A1:A100)
or name that range as "data"
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

in message
news:[email protected]...

 

[Bob Phillips]

Try

=SUMPRODUCT(--(A2:A20<>""),1/COUNTIF(A2:A20,A2:A20&""))

 

[Patricia H]

Yes that worked, thanks!!



Bernard Liengme wrote:

Here is the formula=SUMPRODUCT(--(data<>""),1/COUNTIF(data,data&""))replace
15-Mar-10

Here is the formula
=SUMPRODUCT(--(data<>""),1/COUNTIF(data,data&""))
replace 'data' by the range (such as A1:A100)
or name that range as "data"
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

in message

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to display a Gravatar Image with 100 Percent Client Script Code
http://www.eggheadcafe.com/tutorial...c-b0877c10ecb4/how-to-display-a-gravatar.aspx