| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining IF, ANd and SUM functions in a formula
try
=sumproduct((Source!$A$2:$A$9999="X")*(Source!$C$1 :$C$9999="Y")*Source!$G$1:$G$9999) -- Don Guillett Microsoft MVP Excel SalesAid Software "RJanz" wrote in message ... 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 | |||
Threaded Mode
