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

IF ColumnA = ltr Add Column B
 

Use

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514542

IF ColumnA = ltr Add Column B
 

Try this.

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

Where A10 has the job acronym.

HTH
Regards,
Howard

"maril" wrote in message
...
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

IF ColumnA = ltr Add Column B
 

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

"L. Howard Kittle" wrote:

Try this.

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

Where A10 has the job acronym.

HTH
Regards,
Howard

"maril" wrote in message
...
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