defining a sum using named rows and columns

  • Thread starter Thread starter mr unreliable
  • Start date Start date
M

mr unreliable

hi gang (please be gentle with a newbie),

I am attempting to create a sum in a column named fy_2003, from row named
begint thru row named endint.

I tried this:

=SUM(fy_2003 begint:fy_2003 endint)

which didn't work. Then I tried some variations (the row name first, etc),
nothing I tried worked.

Also, is there any way to specify the desired column just ONCE, and then the
range of rows.

Finally, am I WAY off base? Should I be using something else (like a range
specification) to do this?

tiafah, jw

p.s. excuse me if this is the wrong ng. could you suggest a more
appropriate ng?
 
Try:

=SUM(OFFSET(fy_2003,ROW(begint)-1,,ROW(endint)-ROW(begint)
+1))

HTH
Jason
Atlanta, GA
 
You were almost there! Obviously read the documentation well: you don't see
the intersection operator used that often.
The right syntax was:

=SUM((fy_2003 begint):(fy_2003 endint))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top