TabletWise.com
 

0205 COUNT() vs. COUNTA() vs. COUNTBLANK() vs. COUNTIFS()

3 minutes
Share the link to this page
Copied
  Completed
You need to purchase the class to view this lesson.
One-time Purchase
$99.99
List Price:  $139.99
You save:  $40
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
A$139.44
List Price:  A$195.22
You save:  A$55.78
৳8,481.77
List Price:  ৳11,874.82
You save:  ৳3,393.05
CA$132.34
List Price:  CA$185.28
You save:  CA$52.94
CHF 91.10
List Price:  CHF 127.54
You save:  CHF 36.44
kr631.43
List Price:  kr884.03
You save:  kr252.59
€84.79
List Price:  €118.72
You save:  €33.92
£76.65
List Price:  £107.32
You save:  £30.66
HK$774.99
List Price:  HK$1,085.03
You save:  HK$310.03
₹7,480.23
List Price:  ₹10,472.62
You save:  ₹2,992.39
RM419.30
List Price:  RM587.04
You save:  RM167.74
₦38,096.19
List Price:  ₦53,336.19
You save:  ₦15,240
kr893.53
List Price:  kr1,250.97
You save:  kr357.44
NZ$151.78
List Price:  NZ$212.50
You save:  NZ$60.71
₱4,895.73
List Price:  ₱6,854.21
You save:  ₱1,958.48
₨16,813.31
List Price:  ₨23,539.31
You save:  ₨6,726
S$137.14
List Price:  S$192
You save:  S$54.86
฿3,106.68
List Price:  ฿4,349.48
You save:  ฿1,242.80
₺728.77
List Price:  ₺1,020.31
You save:  ₺291.53
R1,742.88
List Price:  R2,440.10
You save:  R697.22
Already have an account? Log In

Transcript

Hello everybody. In this video session we talk about a cluster of formulas who are hovering around the concept of counting. So we have before us couple of formulas called count a is stand for all count all count blank. As the name suggests, it's going to count the blanks in a given array. The Count simply count, we'll see the difference between count versus counting, and a separate formula count, if I'll just be brief about the formula counters, but I'll be going into detail as we progress to the next few sections and lectures. To start with, what is count eight.

If I double click on the cell containing seven notice count is a formula which has just captured an array, a series of values, and it's just counting the cells which has some sort of content inside them. So for example, there are four plus three in total, seven filled up cells, in case there is a space in one of these blank cells. It also counts that so it means count a count all including space, including numbers alphanumeric, whatever it finds out, there are currently 10 counts in the given array. Compared with count, count a versus count. Count is a formula which only counts the specific cell instances where numbers exist. For example, in this case, out of the 10 cells, which I'm going to highlight, right now, there is one cell which has word called check, it has not counted that and count formula has just been what nine, of course goes without saying that if it's a blank cell, it will not be counted.

So it counts only the number of cells which has numeric values in sitemap numbers stored as number. Now, on the other hand, a formula count blank quite often used to find out whether in a given series of data how many cells contain nothing, so count blank as a double click on this digit three. It says in this array, there are two total three blank cells. And by the way, in case there were any space, it will be counted as a non blank image. This case hence showing you answer to. Now, often it also does happen that you wish to count based on a specific criteria, although I will be talking about counter formula in greater detail later, but right now just want to give a brief overview.

So I wish to find out how many yes instances are there in the given data. So I write count is equal to count if notice I'm writing the extra s to indicate count is S, from our discussions or shortcut key, I'm pressing Ctrl A, and it tells me I need to choose a criteria. So criteria is going to be the letter Yes. And the criteria range is going to be the entire range where possibly yes can be found. So as usual, I'm going to press f4 to ensure that the entire range is not. So criteria is yes, and criteria range is the entire array of values which contains Yes, no all mixed up.

So there are four instances of yes and certified letter word, no doubt is the act to install Instead of note, if I write incomplete, let's see what's going to be incomplete. Oh yes, there are four instances of incomplete. So this is just a cluster of formula which talks about count and now you know the difference between all so as you progress with some more project data, we will be differentiating and using accordingly, those word count formulas.

Sign Up