Monday, February 12, 2018

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!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:

Here's the sheet.