I have a spreadsheet from which I want to pull certain "count" information.
In column R I have a list of hours and in column T I have a list of names (an array created from all the names in the sheet:
{=IFERROR(INDEX(EngList, MATCH(0,COUNTIF($T$1:T1, EngList), 0)),"")}
.
I want to COUNT:
- how many times each name in the array appears in the sheet
- how many times each name in the array has an entry in column R of less than 120
I have tried using COUNTIF and COUNTIFS, but cannot seem to get anything other than 0 as a result. Any ideas?