ExcelBanter - Expansion of COUNT if Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Expansion of COUNT if Question (https://www.excelbanter.com/excel-worksheet-functions/196015-expansion-count-if-question.html)

Adam

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

PCLIVE

Expansion of COUNT if Question

=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

All times are GMT +1. The time now is 10:16 PM.