hardeep

07-09-2009, 12:58 AM

What is the Difference Between these 2 Sumproduct Functions.

SUMPRODUCT(--($H$2:$H$33=H2),--($I$2:$I$33=I2),--($J$2:$J$33))

SUMPRODUCT(($H$2:$H$33=H2)*($I$2:$I$33=I2),$J$2:$J$33)

Name City Total 1st Sumproduct 2nd Sumproduct A X 7.8 24.06 24.06 A X 6.8 24.06 24.06 A X 5.23 24.06 24.06 A X 4.23 24.06 24.06 A Y 12 12 12 D Y 24 47 47 D Y 23 47 47 G X 24.3 24.3 24.3 J Y 12 68 68 J Y 56 68 68 J X 48 112 112 J X 12 112 112 J X 23 112 112 J X 15 112 112 J X 14 112 112 M X 12 40 40 M X 13 40 40 M X 15 40 40 P Y 12 38 38 P Y 14 38 38 P Y 12 38 38 S X 16 35 35 S X 19 35 35 V Y 17 56 56 V Y 18 56 56 V Y 21 56 56 X Z 22 158 158 X Z 23 158 158 X Z 26 158 158 X Z 28 158 158 X Z 29 158 158 X Z 30 158 158

both Give me Same Result

What is the Difference Between "--" and "*" in these Functions

And Which one is the Best or Sufficient.

regards

Hardeep kanwar

SUMPRODUCT(--($H$2:$H$33=H2),--($I$2:$I$33=I2),--($J$2:$J$33))

SUMPRODUCT(($H$2:$H$33=H2)*($I$2:$I$33=I2),$J$2:$J$33)

Name City Total 1st Sumproduct 2nd Sumproduct A X 7.8 24.06 24.06 A X 6.8 24.06 24.06 A X 5.23 24.06 24.06 A X 4.23 24.06 24.06 A Y 12 12 12 D Y 24 47 47 D Y 23 47 47 G X 24.3 24.3 24.3 J Y 12 68 68 J Y 56 68 68 J X 48 112 112 J X 12 112 112 J X 23 112 112 J X 15 112 112 J X 14 112 112 M X 12 40 40 M X 13 40 40 M X 15 40 40 P Y 12 38 38 P Y 14 38 38 P Y 12 38 38 S X 16 35 35 S X 19 35 35 V Y 17 56 56 V Y 18 56 56 V Y 21 56 56 X Z 22 158 158 X Z 23 158 158 X Z 26 158 158 X Z 28 158 158 X Z 29 158 158 X Z 30 158 158

both Give me Same Result

What is the Difference Between "--" and "*" in these Functions

And Which one is the Best or Sufficient.

regards

Hardeep kanwar