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.

Excel 2021 by jiayou

Extract the domain after @ from an email address in A2

Extracts everything after the @ symbol in the email address in cell A2. FIND locates the position of @, LEN calculates the…

=IFERROR(RIGHT(A2,LEN(A2)-FIND("@",A2)),"")
Excel 365 by jiayou

计算A列大于100的B列总和

该公式计算A列中大于100的所有对应B列值的总和。SUMIFS函数允许我们根据一个或多个条件对范围进行求和。这里我们指定条件为A列单元格值大于100，然后对满足条件的B列值进行求和。

=SUMIFS(B:B, A:A, ">100")

Likes and uses count only for signed-in accounts. Fake clicks from the same person are ignored.