Required result with some criteria

[Vishaal]

HI All,

We have the following sheets:-

Sheet1

Book2
	A	B	C	D	E
1	S.No.	Date	Name	Te	Amount
2	1	31-08-2020	Randy	id45	5040
3	2	01-09-2020	Roma	kod65	42676
4	3	01-09-2020	Arthur	pos45	2555
5	4	02-09-2020	Randy	pol85	26913
6	5	02-09-2020	rozi	cld42	25978
7	6	02-09-2020	Arthur	ld6	41736
Sheet1

Result Sheet

Book2
	A	B	C
1	Time Period	From	To
2		31-08-2020	02-09-2020
3
4	Name	Number of times Appers	Total Amount
5	Randy	2	31953
Sheet2

Criteria

1. Sheet2!B2 (Date) - Date will be match from Sheet1!B2:B7
2. Sheet2!C2 (Date) - Date will be match from Sheet1!B2:B7
3. Sheet2!A5 (Name) - Name will be match from Sheet1!C2:C7

In the above result sheet Sheet2!B5 is how many time the name is aperead in Sheet1!C2:C7
In the above result sheet Sheet2!C5 is Total when criteria matched

 

[hrayani]

Hi,

Enter this in B5 on Result Sheet
=COUNTIFS(Sheet1!C2:C7,A5,Sheet1!B2:B7,">="&B2,Sheet1!B2:B7,"<="&C2)

Enter this in C5 on Result Sheet
=SUMIFS(Sheet1!E2:E7,Sheet1!C2:C7,A5,Sheet1!B2:B7,">="&B2,Sheet1!B2:B7,"<="&C2)

 

[Fluff]

How about
=countifs(sheet1!B:B,">="&B2,Sheet1!B:B,"<="&C2,Sheet1!C:C,A5)
and
=sumifs(Sheet1!E:E,sheet1!B:B,">="&B2,Sheet1!B:B,"<="&C2,Sheet1!C:C,A5)

 

[Vishaal]

Thanks Hrayani & Fluffji

solution are working for me

thanks

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[hrayani]

Thanks for the feedback
Regards,