计算A列大于100的B列总和
该公式计算A列中大于100的所有对应B列值的总和。SUMIFS函数允许我们根据一个或多个条件对范围进行求和。这里我们指定条件为A列单元格值大于100，然后对满足条件的B列值进行求和。
=SUMIFS(B:B, A:A, ">100")
Formulas shared by members
Every formula members have published. Copy one to use it. After 10 different signed-in users copy a formula, the author earns extra credits.
Likes and uses count only for signed-in accounts. Fake clicks from the same person are ignored.