Range Sum family
| Range Operations category | Home |
Various ways or summing the items in a range
| Component | What the name means |
|---|---|
| DoBetweenX | Do operations on a the Y values of an X-Y data range |
| SumCat | Sum a range by Category number |
| SumCats | Sum by more than one Category number |
| SumPos | Sums the positive numbers in a range |
| SumNeg | Sums the negative values in a range |
| SumDiv | Sum of one range divided by another |
| SumBounds | Sum within Bounds |
| SumSubRange | Sum a subrange within a range |
| SumCombine | BF version of SumProduct |
| DoIf | Do an operation, such as SUMIF, across several sheets |
| SelCats array function | Select values and create a range based on categories |
Summing elements in a range in specific ways is covered by Excel's SUMIF function, but you may want to look at using one of our, very direct, functions that fulfil many common needs:
- SumNeg and SumPos sum just the negative or positive elements respectively.
- SumCat is one of our most useful functions and adds all the elements that correspond to certain categories. This function is great for analysing lists or accounting entries.
- A related function SumCats, the plural form, allows you to specify more than one category to add. Categories are specified by integer numbers.