spreadsheet code snippets in typescript

create an excel formula that does the following: sum the values in column b only if column c has a value of "dividend" and column e has a value of "xyz". in typescript