yogi_From Table of Date Film Country Count Number of all Films And Unique Films By Country

                                          Google Spreadsheet   Post  #1071
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 8, 2013
user ivpu :(http://productforums.google.com/forum/?zx=eycch1ookas1#!mydiscussions/docs/GvLEQlfzVVY)
Count UNIQUE with additional condition...
Hi,

I try some things but there I can't find solution.

What I have is a table list like this

A             B         C

2.3.2013  Argo      USA

3.3.2013  Argo      USA

4.3.2013  Amour   Austria

6.3.2013  Iron Sky Finland

7.3.2013  Lincoln   USA

And now I need some statistics

Country  Screening Unique films

Austria   1              1

Finland   2              1

USA       3              2

For first column I use:

=SORT(UNIQUE(FILTER(B1:B6;C1:C6<>"")))

For second work as well:

=COUNTIF(C1:C6;SORT(UNIQUE(FILTER(C1:C6;C1:C6<>""))))

But I don't know how I can calculate the third column...

Thank for your help.

--------------------------------------------------------------------------------------------

following is a convoluted solution to the pronlem