RE: Count IF Function

[Stefi]

=SUBTOTAL(103,B2:B5000) returns the number of currently filtered rows.
Regards,
Stefi

„Manos” ezt írta:

> Thank you Gary
> but after filtering i have 250 lines with category a 20 times, category b
> 100, category c 130
> show i want to shee count 3, 1 for category a, category b and category c,
> the uniq, such group by.
>
> Any suggestions?
>
> Sorry i didn't make it clear earlier.
>
>
> "Gary''s Student" wrote:
>
> > You don't need to filter:
> > =COUNTF(B1:B5000,"catagory a")
> > --
> > Gary''s Student - gsnu200771

[Manos]

Thank you Stefi.
Ok i count them how can i group by.....?
i have the total, inside i want to count only the unic entries... not the
double.

[Stefi]

Maybe you need to sort your table by column B, then subtotal by column B
using Count function.
Make sure you have a header in row 1!

Give an example if you need more help! I don't understand how do you want to
count unique entries.

[Manos]

I can not use pivot table
here is an example

colum b -- > filter --> custtom (begins with 2000)
the it gives me 8000 rows.
then in thses filter i have common entries.
So i want to count the unique entires
for example i have 150 rows and the rest are double entries

Thank you for your entry

"Max" wrote:

> Try also a pivot table, which gets you the results in a matter of seconds.
> Select just the col B range, inclusive the col label in B1 (let's assume the
> label is: "Cat"). Click Data > PivotTable. Click Next > Next. In step 3,
> click Layout. Drag n drop "Cat" into both the ROW and DATA area. Click OK >
> Finish. That's it. Hop over to the pivot sheet (to the left) for the results,
> ie a uniques listing of all the categories, and the total counts for each.
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
>