Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...ISTEXT(...B4:B15)*C4:C15)

Calculating sum against the text as criteria

The formula verifies if the cell contains text, if yes then it multiplies the binary array with the corresponding cell value and then calculates the sum with SUMPRODUCT.


Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

Syntax

SUMPRODUCT(array1, [array2], [array3], ...)

Category: Information

Returns TRUE if the value is text

Syntax

ISTEXT(value)

Lets chat on this