Downtime mesurement

[CI Dan]

Hi all,

thank you for looking in to this.

I have crated a formula to count downtime min from ('Master Data'!X column) when downtime category from B29 equal to range 'Master Data'!W column (see below).

=SUMIF('Master Data'!$X$3:$X$4519,"*"&'Data (by date)'!B29&"*",'Master Data'!$W$3:$W$4519)

This formula works fine but I want to add another argument what is too complicated for me. I have a date range column of each downtime ('Master Data'!$AS$3:$AS$4519) and I would like my formula to only sum values if date range is between dates from C3 (start date) and C4 (end date).

Thanks for your help in advance

Dan

 

[AhoyNC]

Use SUMIFS or if your ver. of Excel doesn't have this function then SUMPRODUCT.
See example below.

Excel Workbook
	A	B	C	D	E	F
1	Date	Category	DT		Category	Cat1
2	11/1/2017	Cat1	0:20		Start Date	11/1/2017
3	11/2/2017	Cat2	0:30		End Date	11/22/2017
4	11/3/2017	Cat3	1:20
5	11/4/2017	Cat1	0:15		DT =	0:35
6	11/5/2017	Cat5	0:12
7	11/6/2017	Cat6	0:22			0:35
8	12/5/2017	Cat1	0:05
9	12/6/2017	Cat1	0:14
Sheet

 

[CI Dan]

That's perfect. Thank you

 

[AhoyNC]

You're welcome. Thanks for the feedback.