Creating Sum Formula for specific columns and rows with repeating values

This is my first time on here. So sorry if I'm not the best at explaining this.

I'm trying to see if there is a way to create a formula which calculates values specific to rows with a repeating value.

Essentially. In Column A. I have these "Task Codes" a,b,c,d,e,f ect. These values represent specific tasks and in this column they are repeated multiple times. In Column B I have time spent doing those tasks in minutes.

I'm trying to create a tracking sheet which can show me a tracking report on the inputed tasks. I want to create a formula which sifts through column A selecting, for instance, only the value "task code c" and then correctly adding up the total minutes inputted in Column B.

Is this possible?

In A2 of the tracking sheet you can enter the appropriate code (assuming headers in row 1), then in B2 you can have this formula:

=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)

Assuming your data is on a sheet called Sheet1.

Hope this helps.

Pete

Thanks Pete.

That wasn't quite what I was trying to do but I actually figured it out. At least I think. I'm confused by your answer really.

I learned that I needed to put =SUMIFS(B2:B27283,A2:A27283,"a")

This fuctions allows me to add up the total mins for only the value of a tasks.