1

I'm trying to make a work/project overview, but I'm stuck. Hope you guys can help me out.

enter image description here

The countif formula checks for how much times the criteria is the same. As you can see in the image, Gregor has worked 1 time on Project A. The answer is 1. That's correct. But now I want to check the hours worked on it. So the answer should be 8.

Can someone help me out?

  • I recommend using countifs and sumifs to handle multiple conditions. They make unnecessary your workaround with joining the columns. – user79865 Jul 7 '16 at 10:51
  • Could you give me an example? – Gregor Orchowski Jul 7 '16 at 13:20
1

There is a similar function SUMIF(), which sums the matches instead of counting them.

  • Could you give me an example or just change mines – Gregor Orchowski Jul 7 '16 at 11:36
  • No, this is not a coding service. Read the help on COUNTIF and on SUMIF, and it should be straightforward and simple to do. – Aganju Jul 7 '16 at 11:37
  • Will try it - thanks for your advice – Gregor Orchowski Jul 7 '16 at 11:42
1

I recommend using countifs and sumifs to handle multiple conditions. They make unnecessary your workaround with joining the columns. Example:

=sumifs(E:E, B:B, "Gregor", C:C, "A")

This means: add all values from column E where B is "Gregor" and C is "A".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.