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

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

HTH,
Paul

--

"Adam" wrote in message
...
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