Current location - Training Enrollment Network - Books and materials - How to calculate the sales of a book in a certain year in a spreadsheet
How to calculate the sales of a book in a certain year in a spreadsheet
Please add a complete question, or take a screenshot for example, so that everyone can understand the tricks!

If the date is in column B, the book name is in column C and the sales amount is in column D, enter.

=SUMPRODUCT ((year (B2:B200)= year) *(C2:C200= a book) *D2:D200)

Related articles
  • Norwegian Forest Chapter 4
  • No.842 [Work Summary]
  • Free library near Yuxin subway station
  • Seeking to travel through the novel, the man returned to the Qing Dynasty to grow greenhouse vegetables and buy lottery tickets, which he saw a long time ago.
  • Ode to Zu Chongzhi's poems or couplets! 100 points crazy chase+! Come and answer! !
  • Units directly under Taian Municipal Bureau of Quality and Technical Supervision
  • Urban style: taking stock of landmark buildings in Shenyang
  • A Brief Introduction to the German Encyclopedia of Children's Knowledge
  • Basic introduction of Tianjin Museum
  • College students' career planning book

    • copyright 2024 Training Enrollment Network All rights reserved