sum months excluding months

[excelstudentJBOH]

Date	Product	$/product	Quantity sold	Total Amount Sold
01/01/2017	earrings	5	5	$25
01/02/2017	bracelets	6	10	$60
01/03/2017	rings	7	3	$21
02/01/2017	earrings	5	6	$30
02/02/2017	bracelets	6	11	$66
02/03/2017	rings	7	4	$28
03/01/2017	earrings	5	7	$35
03/02/2017	bracelets	6	12	$72
03/03/2017	rings	7	4	$28

<tbody>
</tbody>

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

 

[mole999]

simple pivot table then exclude feb

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​	F​	G​
1​	Date	Product	$/product	Quantity sold	Total Amount Sold
2​	1/1/2017​	earrings	5​	5​	$25 ​		241​
3​	1/2/2017​	bracelets	6​	10​	$60 ​
4​	1/3/2017​	rings	7​	3​	$21 ​
5​	2/1/2017​	earrings	5​	6​	$30 ​
6​	2/2/2017​	bracelets	6​	11​	$66 ​
7​	2/3/2017​	rings	7​	4​	$28 ​
8​	3/1/2017​	earrings	5​	7​	$35 ​
9​	3/2/2017​	bracelets	6​	12​	$72 ​
10​	3/3/2017​	rings	7​	4​	$28 ​

<tbody>
</tbody>

G2=SUMPRODUCT((MONTH(A2:A10)<>2)*(E2:E10))

 

[excelstudentJBOH]

The thing is that I have a bigger table and I don´t want a pivot table.

Plus, I want the the sum of each product individually by months Jan+Mar excluding those of Feb

Tnx for the replies

 

[Muhammad_Usman]

This is month wise +Product wise summary you can add/less month / product according to your requirments!

Copy past formula in H3 and paste across right down H3:J14.

Formula

=SUMIFS($E:$E,$A:$A,">="&$G3,$A:$A,"<="&EOMONTH($G3,0),$B:$B,H$2)

	G	H	I	J	K
		earrings	bracelets	rings	Total
	January-17	25	60	21	106
	February-17	30	66	28	124
	March-17	35	72	28	135
	April-17				0
	May-17				0
	June-17				0
	July-17				0
	August-17				0
	September-17				0
	October-17				0
	November-17				0
	December-17				0
					0
	Total	90	198	77

<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​
1​	Date	Product	$/product	Quantity sold	Total Amount Sold				$/product	Quantity sold	Total Amount Sold
2​	1/1/2017​	earrings	5​	5​	25​			earrings	10​	12​	60​
3​	1/2/2017​	bracelets	6​	10​	60​			bracelets	12​	22​	132​
4​	1/3/2017​	rings	7​	3​	21​			rings	14​	7​	23​
5​	2/1/2017​	earrings	5​	6​	30​
6​	2/2/2017​	bracelets	6​	11​	66​
7​	2/3/2017​	rings	7​	4​	28​
8​	3/1/2017​	earrings	5​	7​	35​
9​	3/2/2017​	bracelets	6​	12​	72​
10​	3/3/2017​	rings	7​	4​	2​

<tbody>
</tbody>

I2=SUMPRODUCT(($B$2:$B$10=$H2)*($C$1:$F$1=I$1)*(MONTH($A$2:$A$10)<>2)*(C$2:C$10)) copy across and down

 

[excelstudentJBOH]

Thank you all for your responses.
MARZIOTULLIO provided what I was looking for.

I was going crazy trying to figure it out with SUMIFS

 

[excelstudentJBOH]

But if there is a SUMIFS way I would like to find it too.

 

[Tetra201]

But if there is a SUMIFS way I would like to find it too.

Try

=SUM(SUMIFS(C$2:C$10,$B$2:$B$10,$H2,$A$2:$A$10,{"<2/1/2017",">=3/1/2017"}))