So I'm uploading an excel document so you can see what I mean. It's my work hours for the business I run, and I just want to calculate the hours faster, rather than using an =sum formula and entering the cells by hand.

Here's what I want it to do:

Go to column "C" and find all instances of "client contact" for example
Add all the corresponding values up from column "B"
Place them in cell "B20" by "client contact"

Not sure of the best way to do this - curious on your thoughts. Thanks in advance for your help.

Dan

Attached Files

test-workbook.xlsx (9.6 KB, 15 views)