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.
Can anyone assist please? Hopefully I've explained properly.