Hi Ben

As Bob pointed out my formula had a typo, it should have been
$B$2:$B$1000.
However, that would not have worked, as you have now described the data
somewhat differently to that which I had assumed, an column B contains
Text.

Delighted that you found a solution, and thanks for posting back to let
us know.

--
Regards

Roger Govier


"Ben Mehling" wrote in message
...
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!