yogi_Counting number of times a value shares a row with a specific value

Google Spreadsheet   Post  #2577

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-13-2019

question by: Teksura:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/2dN8LeFhyFY;context-place=mydiscussions
Counting number of times a value shares a row with a specific value.

What I'm trying to do on Front is make C3 hold an ARRAYFORMULA that checks the Run Data sheet for me. I input a Character name in C2, and it should check the sheet and return the number of times the Characters listed in B4:B on Front appare in the same row in the Run Data Sheet.

Got the rest of it worked out on my own, but I'm struggling on this one. Not quite sure what I'm doing wrong.

Edit: sorry, fixed my sharing.