I tried it, but got an error. However, a little tinkering got the result I
was looking for. Here's the formula I ended up with:

=SUMIF($B7:$B1000, "Total", $C7:$C1000)

This is actually much simpler than the one I had before.

Thank you for your assistance Roger!