Fortnight wise Sum

I have attached a file with sample data and required output.

Required Output

I just want to automatically calculate the fortnight wise sum of order quantities for each customer in Required output sheet based on the data where date wise data is given.

Regards,

I suggest you put the start dates of each fortnight in your summary table to avoid any ambiguity in selecting data.

=SUMIFS(Data!$E$3:$E$16,Data!$D$3:$D$16,$B4,Data!$B$3:$B$16,">=" &C$3,Data!$B$3:$B$16,"<" &C$3+14)

Thanks John,

for your time to reply my post. actually the actual data consist of records for one year and for 40 customers comprises of few hundred rows. I just require the output (Fortnight wise sum of orders for each customer). I too have this SUMIFs formula in mind but the challenge is to get results for fortnight. I have elaborated the fortnights in the enclosed file for ease of understanding.

You need to enter start/end date for each fortnight e,g in rows 4 and 5

=SUMIFS(Data!$E$3:$E$16,Data!$D$3:$D$16,$B4,Data!$B$3:$B$16,">=" &C$4,Data!$B$3:$B$16,"<=" &C$5)

Thanks John
Your proposed formula gives the required results. Thanks for your time and support.