Current location - Loan Platform Complete Network - Big data management - How to use formulas or functions to find the sum of data greater than 1000 and less than 2000 in excel?
How to use formulas or functions to find the sum of data greater than 1000 and less than 2000 in excel?

Method 1. If the data is in column A and the statistical range is A1:A100, enter or copy the following formula:

=SUMPRODUCT((A1:A100>1000)*(A1 :A100<2000)*A1:A100)

Note: The statistical range should be adjusted based on actual conditions.

Method 2:

=SUMIF(A:A,">1000")-SUMIF(A:A,">=2000")

Related articles
  • Anshun Telecom Big Data Price Inquiry
  • What is the principle of Taobao generation pumping glory crystal?
  • The ratio of men to women in Hebei University
  • How to develop foreign trade customers? What are the ways?
  • New CUHK can not connect to the server how to export data
  • CISP-BDSA refers to what certification
  • If you want to switch to IT, can you teach yourself software testing?
  • The first thing you need to do is to get your hands on some of the most popular products and services in the world, and you'll be able to do it all in one place.
  • Why do you need to learn math is it useful to learn math
  • What is required to take the civil service examination during the 2022 epidemic in Kunming City

    • copyright 2024 Loan Platform Complete Network All rights reserved