I have a worksheet with $ values for different people. The data is sorted by
the name of the person, and I have inserted a blank line between each
person's values. Now I want to calculate the total value of the items for
each person in the blank line (e.g. XXX has values in F2:F11, YYY has values
in F13:F28).

I tried using the AutoSum feature, but I cannot work out how to modify the
code so it will work with a variable number of populated cells. I could
really use a hand here.

Thank you in advance for your help.
MMH :)