| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - IF formula with range of cells
I am trying to create a formula that if a range of cells contains a specific
value AND a range of cells in the next column contains a specific value, then the corresponding cells in the third column will be summed. What I have is below. It recognizes the formula as long as all the cells in the range of the first two columns contain the respective specific values. Can anyone suggest a corrected formula, so the values in the cell ranges can vary? Thanks! =(IF((AND(A2:A500="Value 1",B2:B500="Value 2")),SUM(C2:C500))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a formula to a range of cells | New Users to Excel | |||
| how to use the IF formula with a range of cells | Excel Discussion (Misc queries) | |||
| Range of cells and division formula | Excel Discussion (Misc queries) | |||
| Formula help for using a range of cells! | Excel Worksheet Functions | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
Threaded Mode
