Formula for Adding Multiple Tasks

Hi Excel Gurus,

I am facing a challenge: I am attempting to have an Excel workbook add "time counts" if text from a dropdown menu is the same across several rows. I am attempting to consolidate these "time counts" to one row instead of multiple rows. The text in the dropdown menu can be about 100 different combinations of words but when the words are the same, I want to rows to sum.

Thanks for your assitance in helping me develop a formula. Please let me know if I can clarify my problem in any way.

Regards.

Providing a small sample file (with private data removed) would help to clarify what you want.

Best to show examples of what the end result should look like and why.

I have uploaded a sample Excel file with the problem listed.

Basically I want to consolidate all of the same tasks (Task A = Task A) and aggregate their collective times. You can see from the sample file that the tasks are not in any specific order.

Thanks for the help!

Best,
Owen

In G4 and copied down:

=SUMIF($A$3:$A$12,F4,$D$3:$D$12)

Originally Posted by Cutter

In G4 and copied down:

=SUMIF($A$3:$A$12,F4,$D$3:$D$12)

Thanks, Cutter! What if the dropdown list values (Data Validation) are not on the same worksheet as the actual dropdown menus?

Regards.

Sorry, I don't know what you mean by that.

Do you mean the value in F4 of the formula I gave?
If so, just change that reference of F4 to wherever the value is.