I have several names defined for different cell ranges and I would like to be
able to sum up the values in Column C within a particular name definition.

For example, if a name is defined for range A2:J13, I would like to be able
to sum up column C's values without have to explicitly type C2:C13.

Any ideas of how to go about this?