| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF conditions then add cells together
How do I do the following:
IF H7,J7,L7=6 is true, then add together G7,I7,K7. I want to add all figures together that have a 6 in the adjacent column, and ignore others or add zero. How do I get this formula to drag across to the next column so that the '6' changes to '7' but all else remains the same? Also will the formula work if I have 7 columns of numbers and 7 columns of figures? I'm new to these conditional formulas so a specific formula would be appreciated. Thanks, Lil -- Lil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
| Search multiple cells with conditions, sum and auto populate! | Excel Worksheet Functions | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
![Lil[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
