Hello all, so i have read the different posts on the forum about this same topic but i found the example given to simple to apply to more complex data sets.
For example take a look at this data set.

Account_Number Tran_Amount SIC Year Month
1234567890 $98 5413 2009 1
1234567891 $33 5812 2006 2
1234567892 $37 5812 2009 1
1234567890 $41 5411 2008 3
1234567894 $46 5812 2009 1
1234567892 $51 5413 2007 8
1234567896 $57 5411 2009 1
1234567897 $63 5413 2006 5
1234567890 $70 5411 2009 1
1234567899 $78 5812 2009 1

I would like to know how many Account numbers are there that have a SIC of 5812 in year 2009 and month 1. The answer should be 3.
Also, i wood like to know how many Account numbers had transactions in 2009 month 1 for all SIC but 5411. The answer should be 4.

I believe the formula that should be used here is =SUM(IF(FREQUENCY(
but i cannot figure out of to do it properly.

Your help is greatly appreciated.

Thank you,

Morwick


ps: ( i tried to create a table but i couldn't, 5 columns:Acc #, Tran-Amt, SIC, Year, Month )