Hi all

Here i am still plugging away and trying different formulas year after year but never seeming to get better :-)

I have a workbook where i have:
column AH formatted as numbers only and containing numbers only
Column F with names of people

I want to know for example
john smith (column F) has any number over 100 how many times show up against his name in column AH?
Anne smith (column F) has any number over 100 how many times show up against her name in column AH?
Jane Doe (column F) has any number over 100 how many times show up against her name in column AH?

This is what I have come up with but only ever comes up with zero! very frustrating

=COUNTIFS('QREC Manage Job Requisitions'!AH:AH,">100",'QREC Manage Job Requisitions'!F:F,'260218'!A3)

ANY HELP WOULD BE AMAZING!

Izzy