Buzz
Are you seeking the key to unlocking conditional counting in Excel? Look no further than COUNTIF function! Below, we delve into its description, syntax, and practical usage, guiding you through the process of efficiently tallying data in your Excel spreadsheets.
Description
COUNTIF is your go-to tool for conditional counting in Excel, enabling you to tally data based on predefined conditions with ease.
Syntax
=COUNTIF(range;criteria)
Where range (mandatory) represents the area containing the data you want to count. It can include numbers, arrays, or references containing numbers... Blank values are ignored.
Criteria (mandatory) serves as the condition for counting values within the range. It can be a number, expression, cell reference, or text string.
Your result will be 6 as follows:
3. Count the number of orders with sales quantity >=10 kg.
Use the condition '>=10' in the Sales Qty column and the counting range is the Sales Qty column, the formula function is as follows:
=COUNTIF(D6:D14,'>=10')
Your result will be 6 orders:
4. Count the number of orders with the item name as Cam using the wildcard character *
Instead of typing Cam in the CountIf function condition, you can enter C* to count.
=COUNTIF(B6:B14,'C*')
Here are your results:
So if you need to conditionally count in Excel, you can use the COUNTIF function. This article has introduced you to the description, syntax, usage, and examples of the COUNTIF function in Excel. Hope this article will be helpful to you.
Wishing you success!
