yogi_Count Number Of Employees by Specified Type From Data In Another Sheet

Google Spreadsheet   Post  #2363

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-12-2018

question by: Mike236
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/ZPgJ9uUWzZI;context-place=forum/docs

Arrayformula SUM Countifs

For each Job on Jobs Sheet I need a count of employees by type (Tech1, Tech2) from Employee Sheet.

2 Questions:

1. How to get this into an arrayformula

2. More efficient way to do this?

This works when copied down but fails in an arrayformula:

=IF(LEN(A3:A),SUM(countifs(Employees!A3:A,A3:A,Employees!C3:C,"Tech1")+countifs(Employees!A3:A,A3:A,Employees!C3:C,"Tech2")),)

Here's the sheet.