I want to write an Array to sum a row if the cells contain a certain symbol. For example, I want a sum from A1:A10 if the cell contains "/".

1 Answer 1


Summing the cells in one column under condition that cells in another column contain "/" does not require an arrayformula. It can be done with

=sumifs(A1:A10, B1:B10, "*/*")

where A1:A10 is the sum range, B1:B10 is the condition range, and */* is a pattern that says "contains /" because an asterisk matches any group of symbols.

One can also use sumif for this purpose, but since sumifs can do everything sumif does, and more, I prefer to stick to sumifs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.