IF ColumnA = ltr Add Column B

[Guest]

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

 

[daddylonglegs]

Use

=SUMIF(a:a,"C",b:b)

 

[L. Howard Kittle]

Try this.

=SUMIF(A1:A6,A10,B1:B6)

Where A10 has the job acronym.

HTH
Regards,
Howard

 

[Guest]

THANK YOU SO MUCH! I knew it was something easy, just couldn't put my finger