#1
|
|||
|
|||
SUM up values when different criteria are met
Hi, I need your HELP!!!
I have similar input - please note, I have lots of PROSPECT nbrs with adequate events/meanings/durations - only for simplification, I inserted table with only 2 unique PROSPECT nbrs. My question is - do you have any idea, how to sum up EVENT DURATIONS for PROSPECT nbrs and for EVENTs? I mean, f.e I want to sum up event duration for PROSPECT 123456 - from EVENT 1 Start till EVENT 27 270 Confirmation (00:03 + 10:01 + 0:08 + 125:47). of course, i need same calculation for the other PROSPECT nbr 555555 - from EVENT 1 till EVENT 27 (00:04 + 12:57 + 00:22) Any ideas how to solve my problem?? thanks in advance!!!! PROSPECT EVENT MEANING EVENT DURATION 123456 1 Start 00:03 123456 62 Submission 10:01 123456 27 Confirmation 0:08 123456 27 270 Confirmation - other 125:47 123456 80 Change 00:15 123456 80 Change 00:04 555555 1 Start 00:04 555555 62 Submission 12:57 555555 27 Confirmation 00:22 |
#2
|
|||
|
|||
Could you post a sample of your Excel file by attaching the Excel file?
Hard for me to comprehend without the actual data. Thanks! |
#3
|
|||
|
|||
Why is it that event 80 should not be included in the first sum. What is the rule?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count unique values that match 2 or more criteria | caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
using if and compare with multiple criteria and ranges of values | bill3kradio | Mail Merge | 7 | 11-17-2014 01:06 PM |
Data analysis with four conditions then copies certain values that meets the criteria | AieMPhy | Excel | 0 | 04-24-2014 08:41 PM |
transpose values based on mulitple criteria | mlttkw | Excel | 1 | 12-06-2013 02:00 AM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |