| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summing values within a range
If I have a range of data values anywhere between 1 and 100, in an array
which covers cells A1:Z50, and I wish to sum all the values which fall between a particular range, say 50 and 55, how do I go about doing this? Similarly, how can I create a text string in the format {A1,B22,C19,C54...} etc which includes the cells containing values within my specified range? Is this wishful thinking? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count a range of values in a single cell? | Excel Worksheet Functions | |||
| compute values in a range | Excel Worksheet Functions | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| Return range of values on an "IF" statement | Excel Worksheet Functions | |||
| Summing values of corresponding columns | Excel Worksheet Functions | |||
Threaded Mode
