Help using OFFSET, MATCH and COUNTIFS in Data Validation List

Hi everyone,

I have the following formula in a data validation list and it works great but I need to add additional criteria to the COUNTIF and I can't seem to make COUNTIFS work with it.

Formula:

=OFFSET(Goals_Participant_Start,MATCH(E15,Goals_Participant,0),2,COUNTIF(Goals_Participant,E15),1)

I don't understand why COUNTIFS isn't working as I've tried to use it in the example below.

Formula:

=OFFSET(Goals_Participant_Start,MATCH(E15,Goals_Participant,0),2,COUNTIFS(Goals_Participant,E15],Goals_Status,"Active"),1)

The reason I need the additional COUNTIF criteria is so I don't end up with both Active and Achieved goals listed.

Thanks very much for any help you can provide.