D
Dhazmo
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!!!
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!!!