Help with If/Then

[danstelter]

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

[bobsone1]

Hi
This looks like it will work =SUMIF($C$1:$C$16;$A18;$B$1:$B$16)
I put it in B18 and copied it to B33.

The only issue is that the text in columns A18:A33 and C1:C16 need to be identical, I think this also includes spaces at the end of words.
E.g. the A column had "Research and Development" where as in the C column it was "research & development", but copy and paste will readily solve that problem.

Regards.

[Pecoflyer]

Perhaps use a Pivot Table?

[danstelter]

Thanks for your help - the formula worked! There was an error - I had to change the semicolons to commas. I may do a Pivot Table in the future, but this accomplishes what I need for now.

Dan