Totaling the No. of Hours based on a Data list

[Sherri Goudy]

I have 2 columns of Data. I want to write a formula that says: Find all the 2-1145 in the column, add them up the hours that corresponds to them and give me a total. I can do this in 2 steps of if it is 2-1145, put the hours in a another column and then total that column. I want to do this in one step, rather than copying the hours to another column and then add them. The course numbers may not always be the same from week to week. The data refers to a course and how much time was spent working on it. There about 75 courses or so, so it could be any of them. They are listed on another spreadsheet and then created a data list from them so it is a drop down that they can be selected from.

Course Hours
2-1145 6
2-1145 3
2-1023 6
1-2376 4
2-1023 2

Thanks so much.

 

[T. Valko]

I have 2 columns of Data. I want to write a formula that says: Find all the 2-1145 in the column, add them up the hours that corresponds to them and give me a total. I can do this in 2 steps of if it is 2-1145, put the hours in a another column and then total that column. I want to do this in one step, rather than copying the hours to another column and then add them. The course numbers may not always be the same from week to week. The data refers to a course and how much time was spent working on it. There about 75 courses or so, so it could be any of them. They are listed on another spreadsheet and then created a data list from them so it is a drop down that they can be selected from.

Course Hours
2-1145 6
2-1145 3
2-1023 6
1-2376 4
2-1023 2

Thanks so much.

Try this...

Let's assume your data is in the range A2:B6.

Use a cell to hold the criteria:

• D2 = some course code like 2-1145

Then:

=SUMIF(A2:A6,D2,B2:B6)

 

[Sherri Goudy]

Perfect. Thanks so much.

 

[T. Valko]

Perfect. Thanks so much.

You're welcome. Thanks for the feedback!