In Excel, all non-repeating items in one column correspond to the sum of values in another column.

Enter the following array formula. Don't enter directly after entering. Press three keys? CTRL+SHIFT+ enter？ End. ?

= SUM(IF(B2:b 100 & amp； C2:C 100= " "，，IF(MATCH(B2:B 100，B2:B 100，)=ROW( 1:99)，C2:C 100))

Supplementary Formula 2: Because the same figure in your drawings corresponds to the same amount, I wonder if there are cases where the same figure is different? If so, use Equation 2. Please refer to the drawings for details. ?

This sum formula 1 is an array formula.

= SUM(IF(B2:b 100 & amp； C2:C 100= "",if (matching (B2: b100&; C2:C 100，B2:b 100 & amp； C2:C 100，)=ROW( 1:99)，C2:C 100)))？

Henan Information and Statistics Vocational College summer vacation time 2021

I heard that there is red team in the community. Should I tell the teacher?

What company is idle friend repayment? Do you believe it? Can you tell me what you know?

How to learn big data

Missed the opportunity of 10,000 into millions, 2018 will rely on these to make money

How to learn data mining systematically

What are the top ten brands of propolis in China?

Who is the Secretary-General of Yichang Municipal Government?

Ranking of the Hottest Colleges and Universities

Java big data what to learn?