Function to Count number of Programs with Sub-Programs

[UHD]

Hey guys, thanks in advance for the help. Here's what I'm trying to do. I'm trying to write a function in Excel that counts the number of programs to which an individual contributes. There are three programs and an individual can work on any or all of them. That's basically a simple CountA function. The difficulty is that program three has four different components. However, since the four components are really only 1 program, I want the code to count a person working on any or all of Program 3's four components as 1. The maximum number of programs any individual can work on is 3.

I'm attaching a screenshot of excel with the function I have already written for easier reference. I just removed the = sign so you can read the code.

Excel Help 1.png

The function I wrote works fine for Tom and Di*k but does not work for Harry. Right now it's returning a value of 2 for Harry, which is ridiculous since there is only 1 program Harry works on. The correct values should be: Tom = 3, Di*K = 2, and Harry = 1

Thanks again in advance! Its my first time trying to use if, and, and or functions in excel. Sorry the screenshot is so huge!

[Estevaoba]

I would suggest the following:

Use I as a help column, so I5=COUNTA(E5:H5)
J5=IF(COUNTA(E5:H5)=0,COUNTA(C5:D5),COUNTA(C5,D5,I5))