"sumif" help

[olukay]

Hello there,

Please assist

Please I need a formula that reports how much cookies James sold between [TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl63, width: 118"]03/01/2019 and 09/01/2019. See table below

[TABLE="width: 336"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 336"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Salesman[/TD]
[TD]Cookies [/TD]
[/TR]
[TR]
[TD]01/01/2019[/TD]
[TD]James[/TD]
[TD]2,000[/TD]
[/TR]
[TR]
[TD]02/01/2019[/TD]
[TD]John[/TD]
[TD]2,120[/TD]
[/TR]
[TR]
[TD]03/01/2019[/TD]
[TD]Peter[/TD]
[TD]2,240[/TD]
[/TR]
[TR]
[TD]04/01/2019[/TD]
[TD]James[/TD]
[TD]2,360[/TD]
[/TR]
[TR]
[TD]05/01/2019[/TD]
[TD]John [/TD]
[TD]2,375[/TD]
[/TR]
[TR]
[TD]06/01/2019[/TD]
[TD]Peter[/TD]
[TD]2,390[/TD]
[/TR]
[TR]
[TD]07/01/2019[/TD]
[TD]James[/TD]
[TD]2,405[/TD]
[/TR]
[TR]
[TD]08/01/2019[/TD]
[TD]John[/TD]
[TD]2,420[/TD]
[/TR]
[TR]
[TD]09/01/2019[/TD]
[TD]Peter[/TD]
[TD]2,540[/TD]
[/TR]
[TR]
[TD]10/01/2019[/TD]
[TD]James[/TD]
[TD]2,660[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 118"][/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

Try

=SUMIFS(C2:C11,B2:B11,"James",A2:A11,">="&A14,A2:A11,"<="&A15)

A14 & A15 are your 2 dates

 

[olukay]

This works! Thanks!

 

[gaz_chops]

You're welcome.