software

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, quot;Cquot;) then add the time (B1 B4). Because column A amp; B can go on for
quite a length, a simple this quot;cell plus that cellquot; 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 quot;Cquot;

Thank you


Use

=SUMIF(a:a,quot;Cquot;,b:b)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=514542Try this.

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

Where A10 has the job acronym.

HTH
Regards,
Howard

quot;marilquot; gt; wrote in message
...
gt; I'm trying to create a daily task list.
gt; In column A I have task acronyms, in column B I have the time taken to do
gt; the task. Below all of that, I have a list of task acronyms and would
gt; like
gt; to show the total time for each task by searching for the acronym (for
gt; example, quot;Cquot;) then add the time (B1 B4). Because column A amp; B can go on
gt; for
gt; quite a length, a simple this quot;cell plus that cellquot; would be too time
gt; consuming. Can you help?
gt;
gt; Column A Column B
gt; 1 C 0:21
gt; 2 MP 0:58
gt; 3 MGMT 1:32
gt; 4 C 0:42
gt; 5 N 3:01
gt;
gt; TASK TOTAL TIME
gt; C Total of Column B that finds all cell in Column A
gt; equaling the letter quot;Cquot;
gt;
gt; Thank you
THANK YOU SO MUCH! I knew it was something easy, just couldn't put my finger
on it!

quot;L. Howard Kittlequot; wrote:

gt; Try this.
gt;
gt; =SUMIF(A1:A6,A10,B1:B6)
gt;
gt; Where A10 has the job acronym.
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;marilquot; gt; wrote in message
gt; ...
gt; gt; I'm trying to create a daily task list.
gt; gt; In column A I have task acronyms, in column B I have the time taken to do
gt; gt; the task. Below all of that, I have a list of task acronyms and would
gt; gt; like
gt; gt; to show the total time for each task by searching for the acronym (for
gt; gt; example, quot;Cquot;) then add the time (B1 B4). Because column A amp; B can go on
gt; gt; for
gt; gt; quite a length, a simple this quot;cell plus that cellquot; would be too time
gt; gt; consuming. Can you help?
gt; gt;
gt; gt; Column A Column B
gt; gt; 1 C 0:21
gt; gt; 2 MP 0:58
gt; gt; 3 MGMT 1:32
gt; gt; 4 C 0:42
gt; gt; 5 N 3:01
gt; gt;
gt; gt; TASK TOTAL TIME
gt; gt; C Total of Column B that finds all cell in Column A
gt; gt; equaling the letter quot;Cquot;
gt; gt;
gt; gt; Thank you
gt;
gt;
gt;