SUMIF, XSUMIF
Formula Explanation
The SUMIF function calculates the sum of specified columns for data rows that meet given conditions. The XSUMIF function, when the serial number column is not a formula, implements incremental updates and can trigger automation.
Formula Syntax
Enter in the result column: sumtif(original table sum column, condition)
Original table sum column: The column you want to calculate the sum for, e.g., AH2.
Condition: Filtering conditions for selecting rows from the original table, e.g., AH4 > 90, AH3 = "Phone" and AH3 = AI1.
Usage Example
Calculate the sum of column EP2 for values corresponding to EO2 in column EO3, with the condition EP2 = EO2, and write the result in column EP3.
EP3 = sumif(EO3,EO2=EP2)