Pulling total numbers, help.

[Noxqss38242]

Can I pull total numbers with a formula?
On TAB2
Cell A has a terminal code, ie: MU
Cell B has tech initials, ie: WG1
Cell C has in date
Cell D has in time
Cell E has out date
Cell F has out time
Cell J has total time clocked for that job.

Problem is that the techs have multiple clocking in and out per day. Is there a formula that will pull individual total time for the specific day?

So, he had .4, .7, .3, and .1 for 1/2/20. Total is 1.5.

Tab1
I have the spreadsheet on Tab 1 with the techs initials and end date created that is tracking other information already. I'm wanting to insert a column, let's just say column G with the total found on Tab2 per initial, per day.

So I'm guessing a vlookup situation but somehow pulling the sum total for each tech on each day.

OR

Somehow just sum the total for each day, per tech in a separate column on Tab2, then vlookup only that column for Tab1 based off also the date? Oh the madness!!

 

[Noxqss38242]

Tech Report Card.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Init	Amount
2	1/4/2020	JJ1	1.0							CA2
3	1/4/2020	JJ1	1.0							CCA
4	1/4/2020	JJ1	1.0							JLB
5	1/4/2020	RES	1.8							JB2
6	1/4/2020	JB2	0.6							TRB
7	1/4/2020	DAL	0.6							JMD
8	1/4/2020	CCA	0.9							WG1
9	1/4/2020	LJL	0.7							SPG
10	1/4/2020	CCA	0.8							JH5
11	1/4/2020	LJL	1.0							KWK
12	1/4/2020	CA2	0.8							HBL
13	1/4/2020	WG1	0.9							DAL
14	1/4/2020	JR1	3.3							JNL
15	1/4/2020	WG1	4.4							LRL
16	1/4/2020	BKO	1.0							LJL
17	1/4/2020	CA2	0.3							MM4
18	1/4/2020	KWK	0.5							ZSM
19	1/4/2020	DAL	0.2							DJM
20	1/4/2020	DAL	0.4							CDO
21	1/4/2020	BKO	0.8							BKO
22	1/4/2020	KWK	0.4							JR1
23	1/4/2020	LRL	0.1							DGS
24	1/4/2020	WG1	1.0							BDS
25	1/4/2020	TRB	1.0							TW
Sheet4

Cell Formulas
Range	Formula
K2:K25	K2	=IF(SUMIF($B$2:$B$53,J2,$C$2:$C$53)=0,"",SUMIF($B$2:$B$53,J2,$C$2:$C$53))

 

[CA_Punit]

There is a space in each cell of "Column B". That is why the criteria range doen't Match.
Press Ctrl+Find and replace Space from Column B. It will work

 

[Fluff]

Once you remove the spaces, another option is

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Init	Amount
2	01/04/2020	JJ1	1							CA2	1.1
3	01/04/2020	JJ1	1							CCA	1.7
4	01/04/2020	JJ1	1							JLB
5	01/04/2020	RES	1.8							JB2	0.6
6	01/04/2020	JB2	0.6							TRB	1
7	01/04/2020	DAL	0.6							JMD
8	01/04/2020	CCA	0.9							WG1	6.3
9	01/04/2020	LJL	0.7							SPG
10	01/04/2020	CCA	0.8							JH5
11	01/04/2020	LJL	1							KWK	0.9
12	01/04/2020	CA2	0.8							HBL
13	01/04/2020	WG1	0.9							DAL	1.2
14	01/04/2020	JR1	3.3							JNL
15	01/04/2020	WG1	4.4							LRL	0.1
16	01/04/2020	BKO	1							LJL	1.7
17	01/04/2020	CA2	0.3							MM4
18	01/04/2020	KWK	0.5							ZSM
19	01/04/2020	DAL	0.2							DJM
20	01/04/2020	DAL	0.4							CDO
21	01/04/2020	BKO	0.8							BKO	1.8
22	01/04/2020	KWK	0.4							JR1	3.3
23	01/04/2020	LRL	0.1							DGS
24	01/04/2020	WG1	1							BDS
25	01/04/2020	TRB	1							TW
Master

Cell Formulas
Range	Formula
K2:K25	K2	=IFERROR(1/(1/SUMIF($B$2:$B$53,J2,$C$2:$C$53)),"")

 

[CA_Punit]

How did i forget "1/" trick..

This is amazing to avoid 0. Thanks @Fluff

 

[Fluff]

 

[Noxqss38242]

Ahhh, I missed the space issue?! Well, yeah, that fixed it, thanks for the help.