Current location - Recipe Complete Network - Complete cookbook of home-style dishes - In an EXCEL table, how to automatically sum the values ??in column B corresponding to the same code in column A
In an EXCEL table, how to automatically sum the values ??in column B corresponding to the same code in column A

C1 input

=IF(COUNTIF(A$1:A1,A1)=1,AVERAGE(IF(A$1:A$100=A1,B$1:B$100)) ,"")

Array formula, do not press Enter after inputting, press Ctrl+Shift+Enter to end the calculation, and then fill down.

Related articles
  • Are CGNPC girls easy to get into? They have a Fangchenggang nuclear power company, and the recruitment position has project cost. Is it easy for me to learn project management?
  • 10 ways to make cold lotus root
  • Three stories that caused friends to break up.
  • How did the dragon magic wild warm pot come from?
  • Which home-cooked dishes are delicious and healthy, vegetarian and nutritious, delicious and delicious?
  • What can I eat to gain weight? urgent
  • My grandmother has diabetes and anemia. What should I eat and what should I not eat ~ ~?
  • 20 18 Classical New Year greetings from China
  • Kumquat, which means beauty, always bears fruit after being civilized. What is the reason?
  • Cui Baoshan, president of Jinan Middle School, led a team to check the food safety in the canteen by plane.

    • copyright 2024 Recipe Complete Network All rights reserved