Multiple Conditions Help
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
|