Multiple condition help

[Curtis]

In my Excel sheet

Column B = Month (format 1/7/2007)
Column I = Firm ( 5 different firms)
Column K = either "WO" or "SO"
Column N = either "P" or "W" or "F"

I need to write a formual that will tell me the # of "F" that are "WO" by
specific firm by specific month

Any help is appreciated

Thanks

 

[JE McGimpsey]

In my Excel sheet

Column B = Month (format 1/7/2007)
Column I = Firm ( 5 different firms)
Column K = either "WO" or "SO"
Column N = either "P" or "W" or "F"

I need to write a formual that will tell me the # of "F" that are "WO" by
specific firm by specific month

Easiest way is a pivot table. See

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[jpdphd]

In my Excel sheet

Column B = Month (format 1/7/2007)
Column I = Firm ( 5 different firms)
Column K = either "WO" or "SO"
Column N = either "P" or "W" or "F"

I need to write a formual that will tell me the # of "F" that are "WO" by
specific firm by specific month

Any help is appreciated

Thanks

One way to approach this is with a Pivot Table.
Data > Pivot Table Report...
This is how you get started.
Here is an image that might help you over the first-pivot-table
hurdles:
http://homepage.mac.com/jdilger/Excel/PivotTable2.jpg

Hope this helps.
jpdphd