Intended to create a similar line chart as in “Channel Downtime (All)” but without having multiple tables. By having “SUMIF” we could select the “Yes” or “All” (Column-I) when selecting downtime for Channels. Hope this is possible. I am trying to avoid creating additional sheets when dealing archive data. If you have better idea to handle this please do share with me. I have attached my current workbook for your perusal. Report-2010--Test-.xls
http://www.ozgrid.com/forum/showthread.php?t=27406