| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based off different columns
I am trying to sum numbers in a column based off of another column. I only
want to sum the numbers in a column if the other column meets the criteria. An example: Column B either has a yes or no. Column C has various numbers. I am trying to sum the various numbers in Column C only if Column B has a "yes." Any help would be greatly appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing based off different columns
Try this:
=SUMIF(B1:B100,"yes",C1:C100) HTH, Paul -- "Ag" wrote in message ... I am trying to sum numbers in a column based off of another column. I only want to sum the numbers in a column if the other column meets the criteria. An example: Column B either has a yes or no. Column C has various numbers. I am trying to sum the various numbers in Column C only if Column B has a "yes." Any help would be greatly appreciated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing based off different columns
Try
=SUMIF(B1:B30,"Yes",C1:C30) Mike "Ag" wrote: I am trying to sum numbers in a column based off of another column. I only want to sum the numbers in a column if the other column meets the criteria. An example: Column B either has a yes or no. Column C has various numbers. I am trying to sum the various numbers in Column C only if Column B has a "yes." Any help would be greatly appreciated! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing based off different columns
Ag wrote:
I am trying to sum numbers in a column based off of another column. I only want to sum the numbers in a column if the other column meets the criteria. An example: Column B either has a yes or no. Column C has various numbers. I am trying to sum the various numbers in Column C only if Column B has a "yes." Any help would be greatly appreciated! =SUMIF(B:B,"yes",C:C) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing based on various critiera | Excel Worksheet Functions | |||
| Summing specific Columns based on Criteria | Excel Discussion (Misc queries) | |||
| Summing based on criteria | Excel Worksheet Functions | |||
| Summing every nth row value based upon variable | Excel Worksheet Functions | |||
| Summing based on format | New Users to Excel | |||
Hybrid Mode
