To VLOOKUP or not to VLOOKUP?!?

[BankerSi]

Hello,
I am not sure if this has been covered before on here or if I am even using the right function, but if I explain my problem hopefully you can point me in the right direction.

We are compiling a resourcing sheet showing Full Time Employees/part-time employees. These agents are classed under different headings and in different teams, but one team could have multiple classes in it such as cards,retail,commercial etc etc.

Using VLOOKUP I am trying to total each of these within each team.
Team 1 Team 2
Cards 1.00 Cards 0.56
Cards 0.46 Cards 1.00
Retail 1.00 Retail 1.00
Retail 0.63 Retail 1.00
Commercial 1.00 Commercial 1.00
Commercial 1.00 Commercial 1.00

So for example I am trying to work out how many cards agents that team has, and then retail and so on. Is there a way of getting VLOOKUP to add within the range you set it or do i need to use a different function completely?

[NBVC]

You probably are looking for Sumif().

e.g. =Sumif(A1:A100,X1,B1:B100)

this says sum the corresponding values in B1:B100 where A1:A100 equals the value in X1.

[BankerSi]

Aha, yes that has worked, thanks for your help!

[NBVC]

You are welcome.

Can you please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save