Hi again, Frank,

I have looked at your problem again, and found a couple of other ways
to solve it.

1: use sumif function;

in H34, enter

=SUMIF(D3:D32;"=1";H3:H32)

2: use conditional sum vizard (requires an add-in)

the formula in H34 would look like

=SUM(IF($D$3:$D$32=1;$H$3:$H$32;0))

You can also enter that formula as an array formula, ref. my first reply