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!!

 

[CA_Punit]

You can use the sumifs function to sumup all the times for a specific date in Tab1.

Please post a sheet using xl2bb

 

[Noxqss38242]

Okay, so that was too confusing for me.

I pulled the report differently so here is what I need.

Column A has the date
Column B has initials.
Column C has numbers

Column J has initials
Column K (is where I want the formula)


Example
A. B. C
1/4/2020. WES. .4
1/4/2020. CCA. .5
1/4/2020. WES. .2
1/4/2020. WES. .8


In column K are the list of initials as well

K. L
WES. (FORMULA)
LJL
BKO
CCA
KWK


I need to sum the total time for each tech. If no sum, then blank.

I can move any column to make it easier if need be.

 

[CA_Punit]

Is this you want??

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Initial	Numbers							Initial
2	01/04/2020	WES	4							Wes	14
3	01/04/2020	CCA	5							LJL
4	01/04/2020	WES	2							BKO
5	01/04/2020	WES	8							CCA	5
6										KWK
Sheet1

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

 

[Noxqss38242]

Yes, trying the formula now...

 

[Noxqss38242]

Hmm....just came back with blanks

 

[CA_Punit]

Sorry I didn't understand. Are you getting the sum???

 

[Noxqss38242]

It didn't sum it. All fields came back blank.
I made sure the cells were formatted correctly too.

 

[CA_Punit]

Please copy the data from post 4 and paste it your excel sheet.
If the formula doesn't copy try to do it manually keeping all cells the same and paste only the formulae

 

[Noxqss38242]

I have, it comes back blank