Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining IF, ANd and SUM functions in a formula
I'm trying to add the amounts in a column where two other columns match the
set criteria, however, it is comparing the first cell only to the text specified. Does anyone know how I overcome this or correct the formula below? =IF(AND(Source!$A$2:$A$9999="X",Source!$C$1:$C$999 9="Y"),SUM(Source!$G$1:$G$9999),0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining IF & AND functions | Excel Discussion (Misc queries) | |||
Combining functions AND and OR | Excel Worksheet Functions | |||
Combining IF and OR Functions | Excel Discussion (Misc queries) | |||
Combining IF OR and AND functions | Excel Worksheet Functions | |||
Combining functions | Excel Worksheet Functions |