Version: 2007

Data

Person    Weeks     Type
Name 1    6         Core
Name 1    14        Core
Name 1    6         Core
Name 1    5         Core
Name 1    3         Selective
Name 1    3         Selective
Name 1    6         Selective
Name 2    3         Core
Name 2    4         Selective
Name 3    7         Core

Hello,

Here's my question.

Using the above data I'm trying to add the number of 'Weeks' where the 'Type' is Core and the 'Person' is Name 1(Answer: 31). Then I'll copy this formula for the 'Type' Selective'. I tried Countif, Vlookup and Sum but my knowledge of Excel formulas is all self taught and very limited. I would appreciate your assistance and thank you in advance.

---

Answer from Richard Rost:

This is where the new SUMIFS function in Excel 2007 comes in handy. You need something like this:

=SUMIFS(B1:B6,A1:A6,"=name 1",C1:C6,"=core")

Of course, adjust your ranges accordingly. Here's more help on SUMIFS:

http://599cd.com/tips/excel/sumifs/?key=BlFAlEx