How are the rows variable? If only in that the cells are bold, then,
using my UDF:

=SumBold(K1:K100)

If they vary in other ways, I'm not sure what you're trying to
accomplish.

In article ,
Budget Programmer wrote:

Thanks for answering. But I would like to put a SUM formula in a particular
cell, not just a sum of all the values. The formula I'm looking to insert
would look something like (=K68+K74+K84). The column is constant, but only
the rows are variable.
Do you have a way to make the formula?
--
Programmer on Budget


"JE McGimpsey" wrote:

Take a look he

http://mcgimpsey.com/excel/udfs/sumbold.html

In article ,
Budget Programmer wrote:

Hello,
I have an excel spreadsheet that has sub-totals which are SUM;s on
various
bolded rows. Now, at the bottom of the spredsheet I'd like insert a
formula
which would, for a particular column, add the values of the bolded rows

I can find the bolded row using by using:
If Selection.Font.Bold = True Then......

and I can insert a statement for one row by using something like:
cells(intRowVar, intColVar).Value = "=(R[" & -1 & "]C)"

but I can't seem to find a way to concatinate all the cell references
together and place them in the last row. Since they use relative
referencing, it varies by the time I place it in the final cell.

Thanks for your help.