Search : in
By :

Range in excel

Last answer on Dec 30, 2008 3:32:39 pm GMT 1, on Dec 30, 2008 3:17:43 pm GMT 
 Report this message to moderators

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=

Configuration: Windows 2000
Firefox 2.0.0.20

Best answers for « range in excel » in :
Basic Excel Formulas 2 ShowBasic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Excel – Total Range of Values ShowExcel – Total Range of Values Issue Solution Note Issue I'm trying to get a range of values totalled. I have one set of columns, let’s say column A1 to A200, ranging from -30 up to 1000 and another column adjacent (let’s say B1 to...
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Download Excel Viewer Show
Download Excel Password Recovery Master Show
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 mslizny, on Dec 30, 2008 3:32:39 pm GMT

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.

   
Reply to mslizny
Ask your question Reply
They need your help