Multiple condition help

C

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
 
J

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
Click to expand...

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
 
Top