range in excel Closed

Question

Hello,

how to sum the values of range

eg;


          A            B             C

1     21-30      31-40       41-50     sum=

2     51-60      61-70       71-80     sum=

mslizny · Answer

I think array formulas would handle your situation.  I recently taught a class of financial analysts to use this Excel tool.  There is an explanation on Microsoft.com at:
http://office.microsoft.com/en-us/excel/HA010872901033.aspx

All the best,

Liz on Long Island, N.Y.

Range in excel

1 response

Similar discussions

Subscribe To Our Newsletter!