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:
Find all items that match in the 'Week#' column
Sum their values in the 'CodeCreateTime' column
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.
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
How would you change the which screen pops up first when started?
How to download multiple files with android DownloadManager so that it appears as one notification
Is there a way to force parameter type in rawQuery in Sqlite?
Does using the latest Android operating system in development really matter?
How to treat unmanaged (Unity) exceptions as “crashes” instead of “non-fatals” in Crashlytics
I have a function get_user_agent that returns a few hundred rows from a mysql database
How can i change the timezone of the NOW() function in mySQL, I'm doing a insert with Nodejs
Ok, This is sort of an involved problem, but any help or advice would be incredibly appreciated
I think this one could potentially be resolved in a number of ways, but I've got a headache trying to find a solution