Formula to count seconds

[m_789]

Hi wondering if someone can help me.

So I have a spreadsheet in sheet 1
customers name (a) customers number (b) customer talk time (c)


In sheet 2
it has all the call logs
customer number columns (a)
customer talk time columns (b)


in the call logs a customers number pay appear twice which is fine.

I need to work out how long that customer has spent talking to our agent and paste it in column c on sheet 1

So I am guess it will match the number from sheet 1 column b1 and then search for the number in sheet 2 in column a and give me the total talk time but remeber the number sometimes the call may have called multiple times so it needs to find all entries and give a total sum

Can anyone help please?

[jeffreybrown]

Based on how you describe it, try in B2 copied down on Sheet2 >> =SUMIF(Sheet1!B:B,A2,Sheet1!C:C)