Available in: Desktop version starting Excel 2007, Online Excel 365, Google Sheets
Function Type:
Statistical
Description:
COUNTIFS function in Excel or Google Sheets counts the number of cells within a range that meets all the criteria.
This is the same with COUNTIF function even with the arguments structure.
The only difference is that COUNTIF is singular while COUNTIFS is plural in terms of criteria.
COUNTIFS can handle multiple criteria.
COUNTIF can only work with 1 criteria.
Me personally, I only use COUNTIFS as it is more flexible when there are more criteria needed to be added in the future.
Function Structure:
=COUNTIFS ( range1, criteria1 , [range2], [criteria2] , ... )
Argument Breakdown:
range1 - The first range to evaluate.
criteria1 - The criteria to use on range1.
[range2] - The second range to evaluate.
- As it is with square brackets [] it means that it is not mandatory to have, but there can be more
[criteria2] - The criteria to use on range2.
- As it is with square brackets [] it means that it is not mandatory to have
... - This means that there can be more rangeand criteria arguments added to this function.
Still need help with Excel and Google Sheets?
Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
This post is designated as a reviewer for Excel trainings I conduct.
Feel free to share with anyone. 😉
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
Earn passive income by sharing your internet bandwidth with Honeygain
If you are looking for a charity to donate to, please consider Food for Hungry Minds.
Posted Using LeoFinance Alpha