| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumPRODUCT - calculating result??
This worked a treat! many thanks!!
"Jacob Skaria" wrote: If you are looking to retrive the matching data from ColC for the 2 criterias metioned try the below. Please note that this is an array formula. You create array formulas in the same way that you create other formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula}" =INDEX(Data!$C$2:$C$32001,MATCH(1,(Data!$A$2:$A$32 001=Sheet2!$A3)* (Data!$B$2:$B$32001=H$1),0)) If this post helps click Yes --------------- Jacob Skaria "Dhazmo" wrote: Parameters: Column A = Text Column B = Text Column C = Numerical My formula is: =SUMPRODUCT((Data!$A$2:$A$32001=Sheet2!$A3)*(Data! $B$2:$B$32001=H$1),Data!$C$2:$C$32001) This works fine except where the value/text I want returned in column C looks like this "2008: 36" or "2008-36" - instead I receive "0" or "84" - when I want the formula to return exactly what is in the cell. Please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Percent Change - Comparison Result is Negative | Excel Worksheet Functions | |||
| SUMPRODUCT with AVERAGE result | Excel Worksheet Functions | |||
| IF function inequality is not calculating correct result | Excel Discussion (Misc queries) | |||
| Getting #NUM! result for SumProduct | Excel Worksheet Functions | |||
| Calculating a dollar value of the result between 2 different times | Excel Worksheet Functions | |||
Hybrid Mode
