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

Try this:

P1 = month number
P2 = firm
P3 = WO
P4 = F

=SUMPRODUCT(--(ISNUMBER(B1:B20)),--(MONTH(B1:B20)=P1),--(I1:I20=P2),--(K1:K20=P3),--(N1:N20=P4))

If there will never be empty cells in the date column B then you can
eliminate the ISNUMBER test:

=SUMPRODUCT(--(MONTH(B1:B20)=P1),--(I1:I20=P2),--(K1:K20=P3),--(N1:N20=P4))

--
Biff
Microsoft Excel MVP


"Curtis" wrote in message
...
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