View Single Post
Old 05-14-2017, 11:40 PM   #26
sureLoss
Some kinda newsbreaker!
 
sureLoss's Avatar
 
Join Date: May 2004
Location: Learning Phaneufs skating style
Exp:
Default

Quote:
Originally Posted by EldrickOnIce View Post
Wow I am no good at excel. I want to do something pretty simple i think, but maybe not and regardless, I have no idea how to do it.
I have several tasks that will regularly take place: task1, task2, task3,...
These tasks will alternate in the same 'activity' column (column B)
Each of these tasks will take a varying amount of 'time', and that be recorded next to the activity in column C.
Can I have excel automatically calculate the total hours spent on each specific activity?

thanks
If I understand your problem correctly, sounds like the SUMIFS function.

https://support.office.com/en-us/art...6-611cebce642b

=SUMIFS(C1:C100, B1:B100, "=task1")

for example would add up all the values in column C where column B is "task1"

You can also alternatively use pivot tables as a quick solution too.

Last edited by sureLoss; 05-14-2017 at 11:42 PM.
sureLoss is offline   Reply With Quote
The Following User Says Thank You to sureLoss For This Useful Post: