|Introduction: 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.