| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with SUMPRODUCT?
Hi All, I have to say I'm pulling what little hair I have out over my SUMPRODUCT formula.  Can anyone advise what I am doing wrong with the formula below? Basically I am trying to Sum column AA based on two conditions in Col H and Col S. When I enter the formula i get the #NUM! error? =SUMPRODUCT(--(Sheet1!H:H="LN"),--(Sheet1!S:S="Garry"),Sheet1!AA:AA) Thanks everyone. Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=557152 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
