Count all values in cell from selected column where name on that row is matched
I am looking for support in formula to do a special count. I have been trying COUNTIF, COUNTIFS, SUMIFS, INDEX, MATCH,...but have been unsuccessful.
I am trying to create a summary sheet referenced from main sheet where I can plug in Auto Name from main sheet and it will count how many "Yes" within that specific row (Or how many "No"...How many "N/A", etc)
The count in red is where i am looking for the formula to do the calculation.
Any suggestions or feedback will be very helpful.
Help Article Resources
Check out the Formula Handbook template!