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" .
<tbody>
test a
2...