Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Number and Text Filters Examples in Excel
  • How to Create Thermometer Chart in Excel
  • How to Create Column Chart in Excel
  • Chart Axes in Excel
  • How To Remove Duplicates In Excel Column Or Row?

References

  • How to use Excel ROWS Function
  • How to use Excel ROW Function
  • How to create dynamic named range with OFFSET in Excel
  • How to use Excel OFFSET function
  • How to calculate two-way lookup VLOOKUP in Excel Table

Data Validations

  • Excel Data validation allow uppercase only
  • Excel Data validation number multiple 100
  • Excel Data validation must begin with
  • Excel Data validation only dates between
  • Excel Data validation allow weekday only

Sum if not blank in Excel

by

This tutorial shows how to Sum if not blank in Excel using the example below;

Formula

=SUMIF(range,"<>",sum_range)

Explanation

To sum cells when certain values are not blank, you can use the SUMIF function.

In the example shown, cell G6 contains this formula:

=SUMIF(C5:C11,"<>",D5:D11)

This formula sums the amounts in column D only when the value in column C is not blank

How the formula works

The SUMIF function supports all of the standard Excel operators, including not-equal-to, which is input as <>.

When you use an operator in the criteria for a function like SUMIF, you need to enclose it in double quotes (“”). When you use only “<>” in a criteria, you can think of the meaning as “not equal to empty”, or “not empty”.

Alternative with SUMIFS

You can also use the SUMIFS function sum if cells are not blank. SUMIFS can handle multiple criteria, and the order of the arguments is different from SUMIF. This SUMIFs formula is equivalent to the SUMIF formula above:

=SUMIFS(D5:D11, C5:C11,"<>")

With SUMIFs, the sum range always comes first.

Post navigation

Previous Post:

How to use Excel CHOOSE Function

Next Post:

Customize Ribbon In Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Extract multiple matches into separate rows in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • Invoice status with nested if in Excel
  • SWITCH function example in Excel
  • How to use Excel TRUE Function

Date Time

  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to get Holiday Date from Year in Excel
  • Calculate total hours that fall between two times in Excel
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • TIME function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group numbers with VLOOKUP in Excel
  • Group arbitrary text values in Excel
  • Map inputs to arbitrary values in Excel
  • How to randomly assign people to groups in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Flash Fill in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • Basic text sort formula in Excel
  • Count cells less than in Excel
  • How to calculate percent sold in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning