| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
applying function depending on condition in other cell
Hi experts,
If I have data like this A B ------------- x 2 x 5 y 6 x 1 y 2 x 3 How do I include the values of column B in a function, only if the values have a corresponding x in the A column. For example if I would like to calculate the AVERAGE only of the values in B which has the value X in A. Jonas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying Max Conditonal Formatting to an entire row when condition | Excel Worksheet Functions | |||
| Condition depending on tab colour | Excel Worksheet Functions | |||
| Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
| changing a cell value depending on an If Function/Lookup | Excel Worksheet Functions | |||
| deleting the rows depending on the result of a condition involving two columns. | Excel Programming | |||
Threaded Mode
