Range in excel

Closed
Report
-
 mslizny -
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=

1 reply

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.
0