Modify sumproduct formula

Hi

I have been using a SUMPRODUCT formula noted in column K. The formula sums the values associated column 0100 & 0200 for a specific line. It has worked spectacularly. I tried and failed to modify the formula to accomplish a bit more. I would like to accomplish the following examples: modify the formula in K11 to exclude, not sum column 0200 and (2) to modify the formula in K27 to sum lines 06300 to 10099 but exclude line 09500 column 0100 and 0200 because it is a subtotal.

Appreciate the help.

One other quick question: can you recommend a newbie book illustrating the kinds of formulae and changes noted above?

Thanks again.

Al