How to count Specific name for a Specific Date Range

[Seifeddine87]

hi i have been trying to do this for few hours and i just give up i know you gays you could do it with your eyes closed

1) i want to know how many Specific item has been sold in Specific Date Range
2) i want to know total profit in Specific item has been sold in Specific Date Range

Example

	A	B	C	D	E	F	G	H	I
1	Code	Date	Stock No	Profit	Start Date	End Date
2	3119	05/04/19	40	55	01/04/19	01/05/19
3	4495	05/04/19	75	56
4	4497	05/04/19	40	452	Stock No	Sold items	Profit
5	4662	06/04/19	54	12	40	=?????	=?????
6	3580	07/04/19	45	25	75	1	56
7	4446	08/04/19	45	120	45	2	145
8	3783	08/05/19	45	30	54	1	12
9	1552	08/05/19	40	38
10	8556	08/05/19	75	75

<tbody>
</tbody>

 

[Seifeddine87]

if any one know if there is a way round it or if any one got different strategy i could use to make it happen thank you

 

[Rick Rothstein]

Put this formula in cell F5...

=COUNTIFS(C$2:C$10,E5,B$2:B$10,">="&E$2,B$2:B$10,"<="&F$2)

and this formula in cell G5...

=SUMIFS(D$2:D$10,C$2:C$10,E5,B$2:B$10,">="&E$2,B$2:B$10,"<="&F$2)

and then copy them down to the end of your data.

NOTE: Change the red row numbers to a row number that is equal to or greater than the actual row number for your last data item.

 

[Seifeddine87]

thank you for your help