Skip to content
  • Excel Practice Online
  • Excel Shortcuts
    • Excel Shortcuts for win
    • Excel Shortcuts for Mac
  • Excel Exercises
  • Excel Practice Tests
  • About
  • Contact
  • 0
0 Menu Close
  • Excel Practice Online
  • Excel Shortcuts
    • Excel Shortcuts for win
    • Excel Shortcuts for Mac
  • Excel Exercises
  • Excel Practice Tests
  • About
  • Contact
  • 0
Excel Practice Online

Practice And Learn Excel Online For Free

COUNTIFS Function – Exercise number 1

  • Post published:May 24, 2021

In this exercise, you will be able to practice the COUNTIFS function, for situations where multiple columns have to be checked!

You can view the answers in the Solution tab! 🙂

 

Read more articles

Previous PostSUMIFS Function – Exercise number 1
Next PostPivot Table – Exercise number 1

Functions & Tools

  • Excel Self Assessment Test

  • Excel Basics

  • SUM

  • MAX

  • MIN

  • COUNTA

  • COUNT

  • AVERAGE

  • Filter Tool

  • Sort Data

  • Flash Fill

  • Remove Duplicates

  • IF

  • Nested IF

  • Conditional Formatting

  • SUMIF

  • COUNTIF

  • AVERAGEIF

  • SUMIFS

  • COUNTIFS

  • MAXIFS

  • MINIFS

  • AND/OR

  • ISBLANK

  • VLOOKUP

  • XLOOKUP

  • Pivot Table

  • INDEX MATCH

  • Text to Columns

  • LEFT, MID, RIGHT

  • TEXTBEFORE & TEXTAFTER

  • TEXTSPLIT

  • INDEX

  • MATCH

  • TEXTJOIN

  • CONCAT

  • LEN

  • FIND

  • SEARCH

  • SUBSTITUTE

  • TRIM

  • LOWER, UPPER, PROPER

  • VALUE

  • TEXT

  • DAY, MONTH, YEAR

  • DATE

  • WEEKDAY

  • EOMONTH

  • IFERROR

  • SUMPRODUCT

  • Excel Wildcards

  • Advanced Filter

  • Power Query – Combine data from multiple workbooks

  • Power Query – Column from Examples

  • Unpivot columns using Power Query

  • UNIQUE

  • SORT Function

  • SORTBY

  • FILTER Function

  • RANDARRAY

  • SEQUENCE

  • LET

  • FV

  • VSTACK

  • HSTACK

  • PMT

  • PPMT & IPMT

  • PV

  • Excel Mortgage Calculator

  • How to run a VBA Macro code?

  • Blank Excel Online Worksheet

  • Practice Data Worksheet – Excel Practice Online!

  • Excel Online Cheat Sheet

  • Addition in Excel – Tutorial and Practice

  • Subtraction (minus) in Excel – Tutorial and Practice

  • Multiply Numbers in Excel – Tutorial and Practice

  • Division in Excel – Tutorial and Practice

  • LAMBDA

  • FORMULATEXT Function

  • Concatenate

  • Terms and Conditions
  • Privacy Policy
Copyright © 2021 - EXCEL PRACTICE ONLINE
×
×

Cart

Terms and Conditions - Privacy Policy