excelstudentJBOH
New Member
- Joined
- Aug 24, 2017
- Messages
- 11
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Product[/TD]
[TD]$/product[/TD]
[TD]Quantity sold[/TD]
[TD]Total Amount Sold[/TD]
[/TR]
[TR]
[TD]01/01/2017[/TD]
[TD]earrings[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]$25[/TD]
[/TR]
[TR]
[TD]01/02/2017[/TD]
[TD]bracelets[/TD]
[TD]6[/TD]
[TD]10[/TD]
[TD]$60[/TD]
[/TR]
[TR]
[TD]01/03/2017[/TD]
[TD]rings[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]$21[/TD]
[/TR]
[TR]
[TD]02/01/2017[/TD]
[TD]earrings[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]$30[/TD]
[/TR]
[TR]
[TD]02/02/2017[/TD]
[TD]bracelets[/TD]
[TD]6[/TD]
[TD]11[/TD]
[TD]$66[/TD]
[/TR]
[TR]
[TD]02/03/2017[/TD]
[TD]rings[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]$28[/TD]
[/TR]
[TR]
[TD]03/01/2017[/TD]
[TD]earrings[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]$35[/TD]
[/TR]
[TR]
[TD]03/02/2017[/TD]
[TD]bracelets[/TD]
[TD]6[/TD]
[TD]12[/TD]
[TD]$72[/TD]
[/TR]
[TR]
[TD]03/03/2017[/TD]
[TD]rings[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]$28[/TD]
[/TR]
</tbody>[/TABLE]
Good day to all,
I want to know if someone can help solve this problem.
I want to sum all sales from earrings and others respectively,
like in the table sales(Jan+Mar) excluding Feb
Any help will be greatly appreciated
<tbody>[TR]
[TD]Date[/TD]
[TD]Product[/TD]
[TD]$/product[/TD]
[TD]Quantity sold[/TD]
[TD]Total Amount Sold[/TD]
[/TR]
[TR]
[TD]01/01/2017[/TD]
[TD]earrings[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]$25[/TD]
[/TR]
[TR]
[TD]01/02/2017[/TD]
[TD]bracelets[/TD]
[TD]6[/TD]
[TD]10[/TD]
[TD]$60[/TD]
[/TR]
[TR]
[TD]01/03/2017[/TD]
[TD]rings[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]$21[/TD]
[/TR]
[TR]
[TD]02/01/2017[/TD]
[TD]earrings[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]$30[/TD]
[/TR]
[TR]
[TD]02/02/2017[/TD]
[TD]bracelets[/TD]
[TD]6[/TD]
[TD]11[/TD]
[TD]$66[/TD]
[/TR]
[TR]
[TD]02/03/2017[/TD]
[TD]rings[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]$28[/TD]
[/TR]
[TR]
[TD]03/01/2017[/TD]
[TD]earrings[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]$35[/TD]
[/TR]
[TR]
[TD]03/02/2017[/TD]
[TD]bracelets[/TD]
[TD]6[/TD]
[TD]12[/TD]
[TD]$72[/TD]
[/TR]
[TR]
[TD]03/03/2017[/TD]
[TD]rings[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]$28[/TD]
[/TR]
</tbody>[/TABLE]
Good day to all,
I want to know if someone can help solve this problem.
I want to sum all sales from earrings and others respectively,
like in the table sales(Jan+Mar) excluding Feb
Any help will be greatly appreciated