Using countif and offset for a named range

Hi,

I have a spreadsheet (attached) that contains id#'s, activity date, create date, datediff and employee nam.

I want to count

• the number of invoices for each employee
• the number of ids created before the activity date,
• the number of ids creaetd after the activity date,

without having to enter the range for each employee.

I am able to do this using countifs (=COUNTIF(range,"enployee name" and =COUNTIF(range,">"&0).

Since the employees and number of activities differ each time the report is run, is there a way automate this or do this with dynamic ranges, countifs and offsets?

Thanks!