counting multiple conditions

[Dick Berens]

Hello
I have set up a calendar within Exce
Column A1:A10 are workers. Some of the workers take care of job A, (BB1:BB4)some take care of job B(BA1:BA6
The workers do certain tasks that need counting(BC1:BC5
The Days are from B1:AE10
is there a way through array to count the numer of "Job A" workers(BB1:BB4) available for "tasks" noted in BC1:BC
exampl
{=SUM(IF(a1:a10=BB1:BB4,IF(B1:B10=BC1:BC5,1,0)))

thanks for any hel
Dick Beren

 

[Frank Kabel]

Hi
try the following array formula (entered with
CTRL+SHIFT+ENTER):
=SUMPRODUCT(--(A1:A10=TRANSPOSE(BB1:BB4)),--
(B1:B10=TRANSPOSE(BC1:BC5)))

-----Original Message-----
Hello,
I have set up a calendar within Excel
Column A1:A10 are workers. Some of the workers take care

of job A, (BB1:BB4)some take care of job B(BA1:BA6)

The workers do certain tasks that need counting(BC1:BC5)
The Days are from B1:AE10.
is there a way through array to count the numer of "Job

A" workers(BB1:BB4) available for "tasks" noted in BC1:BC5

 

[Frank Kabel]

Hi
should work (if you use an english version). But if you like email me
your file
email: frank[dot]kabel[at]freenet[dot]de

 

[Dick Berens]

Frank
I sent the spreadsheet a couple of days ago. Did you receive it? If so any comments
thanks

Dick