Countif with Index-Match

[Jasesair]

I have some mocked up data below. I'm not sure how but I'm wanting to lookup James in column B and count how many values there are for James...but only count the first # columns based on A1. In the below case, A1 is 4 so the formula would count from cells C5:F5. Result for James would be 1. If looking up John, the result would be 3.

Can anyone assist please? Hopefully I've explained properly.

 

[steve the fish]

Heres a couple:

=COUNT(INDEX($C$3:$C$6,MATCH("James",$B$3:$B$6,0)):INDEX($C$3:$M$6,MATCH("James",$B$3:$B$6,0),$A$1))
=COUNT(OFFSET($B$2,MATCH("James",$B$3:$B$6,0),1,1,$A$1))

Both end up doing the same thing.

 

[Jasesair]

Many thanks. I went with the first option, and it works perfectly.