Count value occurences accross columns and rows

Hi and welcome to the forum

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Try this...


Data Range

	A	B	C	D	E	F	G
2	curtis	jake	jim	frank	-----	frank	3
3	frank	jon	jack	curtis		jim	3
4	jon	jake	jim	frank		jake	2
5	jim	curtis	jack	curtis		curtis	4
6						jack	2
7						jon	2
8

Enter this array formula** in F2:

=IFERROR(LOOKUP("zzz",INDEX(IF(COUNTIF(F$1:F1,A$2:D$5),0,A$2:D$5),MIN(IF(COUNTIF(F$1:F1,A$2:D$5),"",ROW(A$2:D$5)-ROW(A$2)+1)),0)),"")

Note that the formula refers to cell F1. It is assumed cell F1 is a column header and that cell must not contain a name that is also in the data range A2:D5.

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Enter this formula in G2:

=IF(F2="","",COUNTIF(A$2:D$5,F2))

Select F2:G2 and copy down until you get blanks.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

You're welcome. Thanks for the feedback!