Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Automatic Cell Expansion Possible? | Excel Discussion (Misc queries) | |||
Formula Expansion | Excel Discussion (Misc queries) | |||
Row Expansion | Excel Worksheet Functions | |||
Automatic Chart Expansion Problem | Charts and Charting in Excel | |||
number expansion and contraction | Excel Worksheet Functions |