Sum Column Based On Another Column
Here's what I want to do:
I have 2 columns, one is "time" and the other column is "code". Time is basically time (0:30, 0:40, 0:45, and so on). Code is a number between 1 and 6. What I want to do is calculate the total time from the time column based on the code from the code column.
For instance, I would like to find out what the total time for code 1 is, the total time for code 2, and so on.
I am planning to have this as a chart in a new worksheet.
Let me know how I would do this.
Thanks in advance. Appreciate your feedback.
Video Tutorials / Excel Dashboards Reports