Previous Topic Next Topic

Range in excel

Closed
1 - Dec 30, 2008 at 10:17 AM
 mslizny - Dec 30, 2008 at 10:32 AM
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=
Related:

1 response

Answer 1 / 1
mslizny
Dec 30, 2008 at 10:32 AM
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.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response