Let me explain what I am doing. I am writing a CSV file programatically. I 
have a column of document names across the top.

Doc1 Doc2 Doc3

Each row consists of a format name and the count of that format in each 
document's column.

Heading1  10   5   9
Body   40   12   22

So, for the last column in each row, I want to put a formula that will sum 
each format's count. I want to write a generic formula, if possible, because 
I don't want to keep track of the row number as I write the data. That is 
because I am writing some other things to the report.

Rick

> I am using a formula in Excel to sum the values in a row:
>
> =SUM(B2:F2)
>
> Is there a way to use a generic row reference in a formula? For
> example, I don't know for sure at run time if the data and formula
> is going to end up in the second row. What I want is something
> like this
>
> =SUM(B#:F#)
>
> where the # sign would indicate the current row containing the formula.


Reply via email to