How do I `SUM` by multiple columns in Excel
- by dwwilson66
I have a comma delimited file that includes two columns date/time (which imports as Excel's mm/dd/yyyy hh:mm custom format) and status of 1 or 0. The status represents a piece of equipment either being on or off. I'm trying to generate a graph that will show, hours up vs. down by day.
CONSIDER:
1/1/2012 00:00, 1
1/1/2012 03:00, 0
1/1/2012 14:00,…