Hi I am working on a vacation tracker and need find the name of an employee in a table then count the number of times "H" is in the row of the name.
Basically i need to find the row for a work on another sheet then count the number of holidays they have taken, this will then be expanded to sick days and other absence based on a character reference in the table.
I am have tired the following but get an error:
I will then replicate this across multiple sheets
Basically i need to find the row for a work on another sheet then count the number of holidays they have taken, this will then be expanded to sick days and other absence based on a character reference in the table.
I am have tired the following but get an error:
Excel Formula:
=COUNTIF(INDIRECT(&"'Jan2021'!"&MATCH(A10,'Jan2021'!A9:A44,0)&":'Jan2021'!"&MATCH(A10,'Jan2021'!A9:A44,0)&"),"H")