There is currently no way to do a SUMIF function within Alma Analytics. In Excel, a formula like =SUMIF(A:A, A2, B:B) will perform the following operation: it will look for duplicates in the first column and if present, sum the numbers in the second column and output them in the third column. This is particularly helpful when trying to determine something like the total number of serial volumes per library (or some similar metric) without using the subtotal function. The subtotal function creates an additional row at the end of each unique set of instances instead of putting this data in a column. A column would be cleaner and easier to work with in many situtations.