Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |