I would like to count whether any 1, 2, 3, 4, or 5 specific cells in a row are used (text or number) and based on that number insert another value from a fixed cell into the 6th cell. Something like this. Is this possible please?
H I J K
25 50 75 100
Jim Peter George Fred 4 names so $K$1
Jim George Fred 3names so $J$1
Bookmarks