Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum cells compare cells
How do I sum values for a column where column 1 matches column 2 cells. The
sum value is in column 3. Example: col1 col2 col3 9B 9b 15 AA BB 7 dd dd 9 24 Total sum where values are =. Also, do the same totals on another sheet without repeating col1. In other words sheet2 has only cols 2 & col3. I am sure this is simple. But I am new to Excel. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum cells compare cells
In article ,
KenB wrote: How do I sum values for a column where column 1 matches column 2 cells. The sum value is in column 3. Example: col1 col2 col3 9B 9b 15 AA BB 7 dd dd 9 24 Total sum where values are =. Try... =SUMPRODUCT(--(A1:A3=B1:B3),C1:C3) Also, do the same totals on another sheet without repeating col1. In other words sheet2 has only cols 2 & col3. I am sure this is simple. But I am new to Excel. Can you elaborate? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum cells compare cells
=SUMPRODUCT(--(A1:A20=B1:B20),C1:C20)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "KenB" wrote in message ... How do I sum values for a column where column 1 matches column 2 cells. The sum value is in column 3. Example: col1 col2 col3 9B 9b 15 AA BB 7 dd dd 9 24 Total sum where values are =. Also, do the same totals on another sheet without repeating col1. In other words sheet2 has only cols 2 & col3. I am sure this is simple. But I am new to Excel. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum cells compare cells
The sumproduct did not work. column 1 contains text correct answers, column2
contains answers to match to column 2, column 3 contains values that I want to sum for the entire columns if col1 =col2. example: column total = sum of all col3 values where col1 =col2. Each col has several rows. The 2nd part was col2 & col3 are on other sheets but the correct answers(col1) are the same. Thanks "Domenic" wrote: In article , KenB wrote: How do I sum values for a column where column 1 matches column 2 cells. The sum value is in column 3. Example: col1 col2 col3 9B 9b 15 AA BB 7 dd dd 9 24 Total sum where values are =. Try... =SUMPRODUCT(--(A1:A3=B1:B3),C1:C3) Also, do the same totals on another sheet without repeating col1. In other words sheet2 has only cols 2 & col3. I am sure this is simple. But I am new to Excel. Can you elaborate? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum cells compare cells
If I now understand you correctly, assuming that Sheet2!A2:B4 contains...
9b 15 BB 7 dd 9 ....and Sheet1!A2:A4 contains... 9B AA dd ....try the following formula... =SUMPRODUCT(SUMIF(Sheet2!$A$2:$A$4,Sheet1!A2:A4,Sh eet2!$B$2:$B$4)) If this is not what you're looking for, can you elaborate? In article , KenB wrote: The sumproduct did not work. column 1 contains text correct answers, column2 contains answers to match to column 2, column 3 contains values that I want to sum for the entire columns if col1 =col2. example: column total = sum of all col3 values where col1 =col2. Each col has several rows. The 2nd part was col2 & col3 are on other sheets but the correct answers(col1) are the same. Thanks "Domenic" wrote: In article , KenB wrote: How do I sum values for a column where column 1 matches column 2 cells. The sum value is in column 3. Example: col1 col2 col3 9B 9b 15 AA BB 7 dd dd 9 24 Total sum where values are =. Try... =SUMPRODUCT(--(A1:A3=B1:B3),C1:C3) Also, do the same totals on another sheet without repeating col1. In other words sheet2 has only cols 2 & col3. I am sure this is simple. But I am new to Excel. Can you elaborate? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
compare cells of different external documents | Excel Worksheet Functions | |||
How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
Compare data - one cell to multiple cells | Excel Discussion (Misc queries) | |||
How do you compare text in cells | Excel Worksheet Functions |