Short Tips#0027: How to count cells containing any part of text
Tag: COUNTIF
Lesson#49: Make a parent Gantt chart from a data table
Here I have to make a parent Gantt chart from a data table. It is a Gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value …
Lesson#49: Make a parent Gantt chart from a data table Read more »
Lesson#46: Count cells that contain any text or part of that text
This character “*” (Asterisk) is used to denote any text within a cell. 1. If you use the formula =COUNTIF(range, “*”) then it will count the numbers of cells having any text within range. 2. If you use =COUNTIF(range, “CEMENT*”) …
Lesson#46: Count cells that contain any text or part of that text Read more »
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF
In our 8th lesson, I will discuss COUNT, COUNTIF, and the combination of IF and COUNTIF. COUNT is a function that counts the number of cells in a range that contains a number. I have given an example of COUNT …
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF Read more »