=SUMPRODUCT(('Sites Task List'!$B$2:$B$5000=$C4)*('Sites Task
List'!$K$2:$K$5000<"Completed")*('Sites Task
List'!$L$2:$L$5000<"Completed")*('Sites Task
List'!$R$2:$R$5000<{"","Completed"})*('Sites Task
List'!$S$2:$S$5000<{"","Completed"})*('Sites Task
List'!$T$2:$T$5000<{"","Completed"})*('Sites Task
List'!$U$2:$U$5000<{"","Completed"}))

What I am trying to calculate in the above formular is this:
If Columns K and L: Values are not equal to "Completed" then count the cells
in
Columns R, S, T, & U:
where values are NOTBLANK and are not equal to "Completed".
For example if R <"" or "Completed" but S, T, and U are I want to count
that row, or
if R and S are <"" or "Completed" but T, and U are I want to count that row

and so on.