Unique values * buy/sell * market ?

Hey Guys!

I´ve been trying to figure this out for 2 days.

Attached file has 3 columns. a) market b)buy or sell c)price.

QUESTION: In Madrid market - at how many unique prices did i buy stocks?


this is what i´ve got so far(all these are arrays):
=SUM(IF((IF(A:A="madrid",1,0))*(IF(B:B="buy",1,0)),1,0))
It tells me that 25 buys were done in madrid.

and

This gives me the nr of unique values for column C which is 19.
=SUM(IF(FREQUENCY(N:N,N:N)>0,1))

But how do we combine these two things? I tried like this:
=SUM((IF(((IF(A:A="madrid",1,0)))*(IF(B:B="buy",1,0)),1,0))*(IF(FREQUENCY(C:C,C:C)>0,1,0)))

but... it gives N/A. I think its because the Frequency function gives one value too much, but i dont know.


Any ideas? Maybe its a lot easier some other way?


thanks in advance!!

toorik

It gives me the answer of 16 but the right nr of buys in unique levels done in madrid is 13.

I dont quite understand your formula yet. so i dont know whats wrong. I cant see a word "buy" in that formula so how would it know to count only "buys"?


so still looking...

ps: i have office 2007. if that matters.

seems to be working.

so thanks a mil!