| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions based on conditional values
I'm having problems creating a formula for adding the values of cells in one
column based on the values in another column. It's currency based so I'm trying to figure out how to add all the values in one column based on whether a row in another column contains a certain currency, entered as text. So far I'm coming up with a blank, can any gurus out there help me? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF functions based on conditional values
I should add that I'm using Excel 2002.
Thanks "mishmash" wrote: I'm having problems creating a formula for adding the values of cells in one column based on the values in another column. It's currency based so I'm trying to figure out how to add all the values in one column based on whether a row in another column contains a certain currency, entered as text. So far I'm coming up with a blank, can any gurus out there help me? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF functions based on conditional values
Try SUMIF:
=SUMIF(B:B,"Yes",A:A) In this formula, your values to add are in column A and your criteria for adding these values is in column B. The criteria to match in column B is "Yes". Modify as needed. HTH, Paul "mishmash" wrote in message ... I'm having problems creating a formula for adding the values of cells in one column based on the values in another column. It's currency based so I'm trying to figure out how to add all the values in one column based on whether a row in another column contains a certain currency, entered as text. So far I'm coming up with a blank, can any gurus out there help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
| list two columnar values based on conditional formating (text color) | Excel Worksheet Functions | |||
| Want to make conditional sounds based on cell values in Excel | New Users to Excel | |||
Linear Mode
