"sumif" help

[olukay]

Hello there,

Please assist

Please I need a formula that reports how much cookies James sold between

03/01/2019 and 09/01/2019. See table below A B Salesman Cookies 01/01/2019 James 2,000 02/01/2019 John 2,120 03/01/2019 Peter 2,240 04/01/2019 James 2,360 05/01/2019 John 2,375 06/01/2019 Peter 2,390 07/01/2019 James 2,405 08/01/2019 John 2,420 09/01/2019 Peter 2,540 10/01/2019 James 2,660 <colgroup><col><col><col></colgroup><tbody> </tbody> <colgroup><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[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.