In above example, I wanted the SumProduct of values in columns
C, when the respective cell in column
D was empty.
The solution is to simply introduce the conditional column as another input, with the condition stated in the input.
Sheets does the SumProduct calculations, with each
0, thus making it a Conditional SumProduct :)