Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Merge tables with VLOOKUP in Excel
  • Left Lookup in Excel
  • Approximate match with multiple criteria in Excel
  • How to get address of last cell in range in Excel
  • Offset in Excel

Data Analysis Examples

  • How to perform a t-Test in Excel
  • How to Use Solver Tool in Excel
  • Excel Frequency Function Example
  • Understanding Anova in Excel
  • How to Sort by Color in Excel

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation date in specific year
  • Excel Data validation exists in list
  • Excel Data validation date in next 30 days
  • Excel Data validation require unique number

Count sold and remaining in Excel

by

This tutorial shows how to Count sold and remaining in Excel using the example below;

Formula

=COUNTA(range1)-COUNTA(range2)

Explanation

If you have a list of items, and need to count how many you have total, how many are sold, how remain, etc., you can use the COUNTA function. This can be useful if you are selling tickets, seats, entries, or anything where you maintain and track an inventory of items sold.

Worked Example:   Basic outline numbering in Excel

In the example, the formula in F7 is:

=COUNTA(B5:B11)-COUNTA(C5:C11)

The COUNTA function counts non-blank cells that contain numbers or text. The first COUNTA counts non-blank cells in the range B5:B11 and returns the number 7:

COUNTA(B5:B11) // returns 7

The second COUNTA function does the same with the range C5:C11 and returns 3, since there are 3 non-blank cells in that range:

COUNTA(C5:C11) // returns 3

So, the entire formula is reduced to 7 – 3 and returns 4.

Worked Example:   Count cells that contain odd numbers in Excel

Note that in this case the values that appear in column C don’t matter. They could be the the codes from column B (as in the example), the word “yes”, or simply “x”.

Worked Example:   Check if multiple cells have same value in Excel

Match test

If you need to make sure that the value in column C matches the value in column B, in the same row, you can use a formula based on SUMPRODUCT instead:

=SUMPRODUCT(--(B5:B11=C5:C11))

Post navigation

Previous Post:

Count unique numeric values in a range in Excel

Next Post:

Count total matches in two ranges 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
  • How to check if cell contains some words but not others in Excel
  • Remove first character in a cell in Excel
  • Get first name from name with comma — Manipulating NAMES in Excel
  • How to get first word in Excel
  • Remove text by position in a cell in Excel
  • How to calculate Next working/business day in Excel
  • How to calculate working days left in month in Excel
  • Basic Overtime Calculation Formula in Excel
  • Get day from date in Excel
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • COUPNCD function: Description, Usage, Syntax, Examples and Explanation
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
  • Compound Annual Growth Rate CAGR formula examples in Excel
  • ODDFYIELD function: Description, Usage, Syntax, Examples and Explanation
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles