Please enable JavaScript to view the comments powered by Disqus.


ARRAY(...ARRAYROW(...=SUM(...SUMIFS(...D2:D35,C2:C35,F3:F4))))

How to sum values with multiple OR criteria. 

This formula adds up quantities of goods ordered by either of the two customers. In our example either  Carl Ludwig or Barry French


Used Functions

Category: Math and trigonometry

Adds its arguments

Syntax

SUM(number1,[number2],...)

Category: Math and trigonometry

Adds the cells in a range that meet multiple criteria

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Lets chat on this