IF ColumnA = ltr Add Column B
I'm trying to create a daily task list.
In column A I have task acronyms, in column B I have the time taken to do
the task. Below all of that, I have a list of task acronyms and would like
to show the total time for each task by searching for the acronym (for
example, "C") then add the time (B1+B4). Because column A & B can go on for
quite a length, a simple this "cell plus that cell" would be too time
consuming. Can you help?
Column A Column B
1 C 0:21
2 MP 0:58
3 MGMT 1:32
4 C 0:42
5 N 3:01
TASK TOTAL TIME
C Total of Column B that finds all cell in Column A
equaling the letter "C"
Thank you
|