Summary of typical usage of Excel SUMIF function-excel-php.cn

Home

Topics

excel

Summary of typical usage of Excel SUMIF function

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 17, 2022 pm 01:35 PM

excel

This article brings you relevant knowledge about excel, which mainly introduces related issues about the SUMIF function. The SUMIF function is used to sum the values that meet the conditions in the area. The following is Let's take a look, hope it helps everyone.

Summary of typical usage of Excel SUMIF function

Related learning recommendations: excel tutorial

The SUMIF function is used to sum the values that meet the conditions in a range. She has only 3 parameters:

=SUMIF (conditional area, specified condition, area to be summed)

If the summation area is omitted, the conditional area will be used as the summation area.

Is the SUMIF function really that simple? Today we will take a look at the typical usage of this function.

1. Return the total amount of Ruhua

=SUMIF(B:B,"Ruhua",C:C)

Summary of typical usage of Excel SUMIF function

2. Return the total amount except Ruhua

=SUMIF(C:C,”>900″)

Summary of typical usage of Excel SUMIF function

##3. Total amount greater than 900

=SUMIF(C:C,”>900″)

Summary of typical usage of Excel SUMIF function

4. The total amount below the average

=SUMIF(C: C,"Note that when using other formulas as summation conditions, if the comparison operators greater than, less than, and not equal are used before the formula of the summation condition, , use half-width quotation marks before and after the operator, and use the connector & to connect the comparison operator to the formula.

Summary of typical usage of Excel SUMIF function

5. Return the total amount of money whose name contains "花"

=SUMIF(B:B,"*花*",C:C)

Summary of typical usage of Excel SUMIF function

6. Return the amount before the current date

=SUMIF(A:A,”

Summary of typical usage of Excel SUMIF function

7. Ignore error value summation

=SUMIF(C:C,”The summation parameter is omitted, Taking the condition area C:C as the summation area, the summation condition is

Summary of typical usage of Excel SUMIF function

8. Return the total amount of Ruhua and Qiuhua

=SUM(SUMIF(B:B,{"Ruhua","Qiuhua"}, C:C))

Summary of typical usage of Excel SUMIF function

9. Sum of staggered columns

=SUMIF(B:H,K3,C:I)

Conditions and summation areas are misquoted.

If column B:H is equal to the name in cell K3, sum the values in the same position in column C:I.

Summary of typical usage of Excel SUMIF function

Related learning recommendations:

excel tutorial

The above is the detailed content of Summary of typical usage of Excel SUMIF function. For more information, please follow other related articles on the PHP Chinese website!

Statement

This article is reproduced at:Excel Home. If there is any infringement, please contact admin@php.cn delete

MEDIAN formula in Excel - practical examplesApr 11, 2025 pm 12:08 PM

This tutorial explains how to calculate the median of numerical data in Excel using the MEDIAN function. The median, a key measure of central tendency, identifies the middle value in a dataset, offering a more robust representation of central tenden

Google Spreadsheet COUNTIF function with formula examplesApr 11, 2025 pm 12:03 PM

Master Google Sheets COUNTIF: A Comprehensive Guide This guide explores the versatile COUNTIF function in Google Sheets, demonstrating its applications beyond simple cell counting. We'll cover various scenarios, from exact and partial matches to han

Excel shared workbook: How to share Excel file for multiple usersApr 11, 2025 am 11:58 AM

This tutorial provides a comprehensive guide to sharing Excel workbooks, covering various methods, access control, and conflict resolution. Modern Excel versions (2010, 2013, 2016, and later) simplify collaborative editing, eliminating the need to m

How to convert Excel to JPG - save .xls or .xlsx as image fileApr 11, 2025 am 11:31 AM

This tutorial explores various methods for converting .xls files to .jpg images, encompassing both built-in Windows tools and free online converters. Need to create a presentation, share spreadsheet data securely, or design a document? Converting yo

Excel names and named ranges: how to define and use in formulasApr 11, 2025 am 11:13 AM

This tutorial clarifies the function of Excel names and demonstrates how to define names for cells, ranges, constants, or formulas. It also covers editing, filtering, and deleting defined names. Excel names, while incredibly useful, are often overlo

Standard deviation Excel: functions and formula examplesApr 11, 2025 am 11:01 AM

This tutorial clarifies the distinction between standard deviation and standard error of the mean, guiding you on the optimal Excel functions for standard deviation calculations. In descriptive statistics, the mean and standard deviation are intrinsi

Square root in Excel: SQRT function and other waysApr 11, 2025 am 10:34 AM

This Excel tutorial demonstrates how to calculate square roots and nth roots. Finding the square root is a common mathematical operation, and Excel offers several methods. Methods for Calculating Square Roots in Excel: Using the SQRT Function: The

Google Sheets basics: Learn how to work with Google SpreadsheetsApr 11, 2025 am 10:23 AM

Unlock the Power of Google Sheets: A Beginner's Guide This tutorial introduces the fundamentals of Google Sheets, a powerful and versatile alternative to MS Excel. Learn how to effortlessly manage spreadsheets, leverage key features, and collaborate

See all articles