| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumPRODUCT - calculating result??
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!!! |
| 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 | |||
Threaded Mode
