Match two values in a range of data, and sum the value in column of all matches?

[GemmaLaura777]

Hi There,

I am trying to match two values in a range of data, if both match, then sum the value in column of all matches. Can anyone advise how I do this please? Many thanks in Advance!

[TABLE="width: 1047"]
<colgroup><col><col span="2"><col><col span="2"><col><col span="8"></colgroup><tbody></tbody>[/TABLE]

 

[Eric W]

Welcome to the board.

Hard to tell without an example, but it sounds like you want SUMIFS.

https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b

 

[Legacy 436357]

Hello,

Can you please clarify ?

Perhaps show an example of what you want and someone here will likely derive a formula.

Thanks