RE: Excel Question

xt in it. HTH Diane === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rick Quatro Sent: Saturday, May 12, 2007 7:10 PM To: framers@lists.frameusers.com Cc: [EMAIL PROTECTED] Subject: OT: Excel Question Hello Framers, I am using a formula in Excel to su

Excel Question

riginal Message- From: framers-bounces+dgcaller=earthlink@lists.frameusers.com [mailto:framers-bounces+dgcaller=earthlink.net at lists.frameusers.com]On Behalf Of Rick Quatro Sent: Saturday, May 12, 2007 7:10 PM To: framers at lists.frameusers.com Cc: framers at omsys.com Subject: OT: Excel Q

Excel Question

eusers.com [mailto:framers-bounces+dgcaller=earthlink.net at lists.frameusers.com]On Behalf Of Rick Quatro Sent: Saturday, May 12, 2007 7:10 PM To: framers at lists.frameusers.com Cc: framers at omsys.com Subject: OT: Excel Question Hello Framers, I am using a formula in Excel to sum the values in a

RE: Excel Question

lf Of Rick Quatro Sent: Saturday, May 12, 2007 7:10 PM To: framers@lists.frameusers.com Cc: [EMAIL PROTECTED] Subject: OT: Excel Question Hello Framers, 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

SOLVED: Re: Excel Question

Either of these works: =SUM(INDIRECT("B"&ROW()):INDIRECT("F"&ROW())) =SUM(INDEX(B:B,ROW()):INDEX(F:F,ROW())) I got the answer on the microsoft.public.excel Usenet group. Thanks to those on Framers that took a stab at it. Rick > Hello Framers, > > I am using a formula in Excel to sum the value

Excel Question

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

SOLVED: Re: Excel Question

Either of these works: =SUM(INDIRECT("B"&ROW()):INDIRECT("F"&ROW())) =SUM(INDEX(B:B,ROW()):INDEX(F:F,ROW())) I got the answer on the microsoft.public.excel Usenet group. Thanks to those on Framers that took a stab at it. Rick Hello Framers, I am using a formula in Excel to sum the values

Re: Excel Question

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 colu

RE: Excel Question

Rick Quatro wrote: > 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

Excel Question

Rick Quatro wrote: > 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

OT: Excel Question

Hello Framers, 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

OT: Excel Question

Hello Framers, 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 =S