COUNTIF checks a range of columns for a specified value, it then outputs the total number of columns with the specified value.
This can be useful if one is attempting to tabulate sums where the columns aren’t numbers but text. For example, if you have created a todo list and assigned certain individuals specific todo items, you can get a count of tasks assigned to a specific individual by using COUNTIF like so:
=COUNTIF(D10:D100,”Dave”)
The above tells Google Sheets to count up the number of times the text “Dave” appears in column D between rows 10 and 100. If you had assigned “Dave” nine tasks then the result would be 9.
Ryan Oglesby writes in May 2017 regarding the current “state” of CSS. Oglesby highlig...
Joey Clover writes on HackerNoon about learner’s syndrome – or FOMO – when it c...
Why you don’t actually need a minimum of 72 PPI for the web.
Great article by Peter Jang that explains what modern JavaScript looks like, aimed especially at ...
James Koice writes a helpful article on what it takes to build a modern JavaScript application in...
Sacha Greif wrote an article for freeCodeCamp that provides a recommended path through the JavaSc...
Auth0 has a great article by Sebastian Peyrott (published 1/2017) on the history of JavaScript. Q...
An article by Andrew Askins on the challenges they faced in estimating software engineering costs...
Alex Wagner writes an article discussing the pros and cons of using static typing in a programmin...
Peter Norvig’s famous article on the process of learning programming.
Explains how to use GitHub’s particular brand of Markdown.