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.
_______________________________________________
You are currently subscribed to Framers as [EMAIL PROTECTED]
Send list messages to [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
or visit
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com
Send administrative questions to [EMAIL PROTECTED] Visit
http://www.frameusers.com/ for more resources and info.
