That is the best way I can describe it.
The first part I have working (summing the length of all cells in a range) using an array formula.
=SUM(LEN(a5:a73)-LEN(SUBSTITUTE(a5:a73,"x","")))
(make sure to use Ctrl+Shift+Enter for the array formula)
In the above example I have column "A" with a list of values with one or many "x"s.
But now I need to sum only the rows where an "x" is in Column B. I'm not sure if it is a countif or lookup or match combination with an array formula.
I've been searching and testing for hours finally broke down and registered to see if some of you gurus can help.
Thank you in advance for your help.
Here is an attached example:
excel-question.xlsx
Bookmarks