The problem is about formula SUMPRODUCT, please help, thanks.

[yyluo]

Hi all,

I want to get a formula. Please help. Thanks!!!

If column A is "test a", SUMPRODUCT (column B,column C), but calculate "DF" in column C as "1" .

I can only get =SUMPRODUCT(B:B, C:C,--(A:A="test a")) , I don't know how to calculate "DF" in column C as "1" .



[TABLE="width: 236"]
<tbody>[TR]
[TD]test a
[/TD]
[TD]2
[/TD]
[TD]100%
[/TD]
[/TR]
[TR]
[TD]test a
[/TD]
[TD]2
[/TD]
[TD]df
[/TD]
[/TR]
[TR]
[TD]test a
[/TD]
[TD]2
[/TD]
[TD]0%
[/TD]
[/TR]
[TR]
[TD]test a
[/TD]
[TD]2
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD]test b
[/TD]
[TD]5
[/TD]
[TD]NA
[/TD]
[/TR]
[TR]
[TD]test b
[/TD]
[TD]5
[/TD]
[TD]NA
[/TD]
[/TR]
</tbody>[/TABLE]

 

[yyluo]

++