| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested SumIf statement
Try to use array function (press ctrl+shift+enter after input the formula)
=SUM(IF((B2:B1589="ICM")*(C2:C1589="Yes"),E2:E1589 )) Yongjun CHEN Project Oriented Spreadsheet Development and Consulting - http://www.geocities.com/udqservices/UDQConsulting.htm ================================= "jlhart76" wrote in message ... I'm trying to sum a group of numbers based on two variables. The SumIf statement isn't working right, neither is SumProduct. Can someone help? Here's what the formula should calculate: IF (B2:B1589="ICM") and IF (C2:C1589="Yes"), then SUM (E2:E1589) -- jlhart76 ------------------------------------------------------------------------ jlhart76's Profile: http://www.excelforum.com/member.php...o&userid=30274 View this thread: http://www.excelforum.com/showthread...hreadid=499413 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a nested SUMIF formula for a number of variables? | Excel Worksheet Functions | |||
| Problem with nested IF_OR statement | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| sumif statement | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Threaded Mode
