Multiple Conditions Help
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 |
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 |
All times are GMT +1. The time now is 01:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com