Excel 2016 - Find matching rows in column b, then sum Column C copy sum in Next Sheet Column A

145
February 04, 2017, at 09:28 AM

I have a worksheet with the following 3 columns on Sheet 1:

ID  Week#   CodeCreateTime
16972   39  4
16980   39  4
19117   39  2
19146   40  2
22362   41  10
20890   41  5

I want to:

  1. Find all items that match in the 'Week#' column

  2. Sum their values in the 'CodeCreateTime' column

  3. Copy the week# and summed value onto Sheet 2 in Column A.

For example, using the above data from Sheet 1, Sheet 2 would have the following values in column A and B:

A       B
39      10
40      2
41      15

Will a sumif(match) work? I have been playing and not having luck.

Answer 1

1) Copy Sheet1!B1:B6 to Sheet2!A1:A6
2) Remove Duplicates on Sheet2!A1:A6
3) In sheet2!B2 type: =SUMIF(Sheet1!$B$2:$B$7,A2,Sheet1!$C$2:$C$7)
4) Drag down rest of rows in Sheet2

READ ALSO
Select random choice from database output

Select random choice from database output

I have a function get_user_agent that returns a few hundred rows from a mysql database

334
How to change timezone of NOW() in mySQL Database in Node.js query?

How to change timezone of NOW() in mySQL Database in Node.js query?

How can i change the timezone of the NOW() function in mySQL, I'm doing a insert with Nodejs

378
Set $mysqli as a global variable for OOP

Set $mysqli as a global variable for OOP

Ok, This is sort of an involved problem, but any help or advice would be incredibly appreciated

303
Zero padding a set of results where two datasets don't match

Zero padding a set of results where two datasets don't match

I think this one could potentially be resolved in a number of ways, but I've got a headache trying to find a solution

215