Forum Discussion
Formula help
Hello, I would like to generate a formula to give the Sum of the numbers with “(B)”, e.g. in this case, 5. The numbers ranges from -9 to 40. I’m thinking about using SUMPRODUCT and LEFT but couldn’t figure out a way. Please help🙏.
For example:
=SUM(--IFERROR(TEXTBEFORE(A1:E1, "("), 0))
or
=SUM(--IF(RIGHT(A1:E1, 3)="(B)", TEXTBEFORE(A1:E1, "(")))
