Note: In order to use the spreadsheet examples, you need to download Business Functions
|SumCats (Values, Categories, [ChosenCategories], [Options], [CatMin], [CatMax])|
|Sum by more than one Category number|
|Performs a summation of a list of numbers, only including those whose corresponding category number matches the selected categories.|
Values for "Options" (or "Opts")
0 or missing: Categories and ChosenCategories are not necessaily in order
Whats good or unique about it
Excel"s SUMIF function is more extensive than SumCat. SumCat has the restriction that a Category has to be a number, and a blank will be interpreted as zero. If you prefer your categories as numbers, you prefer the more rigid style of this function.
You do not have to specify a value for the minimum or maximum category numbers. There are two category selection methods here: one being the chosen categories and the other being the minimum and maximum category numbers. If a category meeets either of these two criteria, then it is selected.