View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adam Adam is offline
external usenet poster
 
Posts: 287
Default Expansion of COUNT if Question

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