Expansion of COUNT if Question

[Adam]

I have two large columns of data, one with numbers and the other is verbal. I
need to write a code in a specific cell that will SUM of a group of those
numbers if the adjacent column meets a certain Criteria.

For Example

Column 1 Column 2
A 2
B 5
C 7
A 8
A 4
B 3
C 2

So i need the code in the cell to Sum up all the numbers in column 2, that
have a A in column 1.

How can i do this??

Thanks in Advance for you help!!!

-Adam

 

[PCLIVE]

=SUMIF(A1:A10,"A",B1:B10)

HTH,
Paul