SUM up values when different criteria are met

Ewitschka · #1 07-15-2016, 02:12 AM

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

tinfanide · #2 07-15-2016, 06:14 AM

Could you post a sample of your Excel file by attaching the Excel file?
Hard for me to comprehend without the actual data.

Thanks!

xor · #3 07-18-2016, 02:40 AM

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