teleren/devto huggingface dataset:
Formulas to Count Cells that contain numbers in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2020-10-31 12:16:48

---
title: Formulas to Count Cells that contain numbers in Excel Office 365!!
published: true
date: 2020-10-31 11:56:59 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-cells-that-contain-numbers-in-excel-office-365/
---

This page will show the **Excel Formulas to count the number of cells that contain any numbers** with its basic syntax and brief explanations. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count cells that have any numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formulas-to-count-cells-that-have-any-numbers.png)](https://geekexcel.com/formulas-to-count-cells-that-contain-numbers-in-excel-office-365/formulas-to-count-cells-that-have-any-numbers/#main)<figcaption id="caption-attachment-16641">Formulas to count cells that have any numbers</figcaption>
## General Formula:

- Use the below formula to count the number of cells that have any numbers in Excel.

**=[COUNT](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/)(Range)**

## Explanations for Syntax:

- **COUNT** – This function will count the number of cells that contain numbers and returns the output in number. Read More of the [**COUNT Function**](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/).
- **Range** -It represents an input range given in a worksheet.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below image, we give the input range in **Column B**.
- Then, enter the formula in the formula bar section.
- After applying the formula, it shows the result in selected **Cell E3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-50.png)<figcaption id="caption-attachment-16640">Example</figcaption>

## A Brief Summary:

In this short tutorial, we described the **formulas for counting the number of cells that contain ant numbers in Excel Office 365** with its best example. Hope that this article is useful to you. If you have any doubts/queries, leave it in the below comment box. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Formulas for Counting the Cells that are Blank in Excel Office 365!!](https://geekexcel.com/wp-admin/post.php?post=16472&action=edit)**
- **[Formulas to Count Cells Contains Equal Values or Numbers in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16324&action=edit)**
- **[Excel Formulas to Count the Cells Less than a Given Number!!](https://geekexcel.com/wp-admin/post.php?post=16409&action=edit)**
- **[Excel Formulas to Count Cells Not equal to Many Things or Values!!](https://geekexcel.com/wp-admin/post.php?post=16439&action=edit)**
Formulas for Counting Cells that Contain Negative Values in Excel!!
Tags: excelformula, excelformulas
Published: 2020-10-31 12:16:39

---
title: Formulas for Counting Cells that Contain Negative Values in Excel!!
published: true
date: 2020-10-31 11:54:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-cells-that-contain-negative-values-in-excel/
---

In this tutorial, we will see the simple and useful **Formulas for counting the number of cells that contain negative values in Excel Office 365** with its brief explanations. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count cells that have negative values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formulas-to-count-cells-that-have-negative-values.png)](https://geekexcel.com/formulas-for-counting-cells-that-contain-negative-values-in-excel/formulas-to-count-cells-that-have-negative-values/#main)<figcaption id="caption-attachment-16635">Formulas to count cells that have negative values</figcaption>

# General Formula:

- The below formula will help to count the number of cells that contain negative values or numbers in Excel.

**=COUNTIF(Range,”<0″)**

## Explanations for Syntax:

- **COUNTIF** – In Excel, the COUNTIF function is used to count the number of cells that match a single condition or criteria.
- **Range** -It represents an input range given in a worksheet.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Operators (<)** – It evaluated the values less than a particular number.

## Example:

- Let’s consider the below image, to count the cells that have negative values.
- First, you need to enter the input values.
- After that, apply the given formula in the formula bar section
- Finally, you can get the result as shown below.
- If you want to count the cells that contain a positive value, use the greater than 0 conditions.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-49.png)<figcaption id="caption-attachment-16629">Example</figcaption>

## Wind-Up:

In this short tutorial, we explained the general and useful **formulas to count the number of cells that have a negative value in Excel Office 365**. Hope that this article is useful to you. If you have any **suggestions,** feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- [**Formulas for Counting Cells that Begin with Some Value in Excel!!**](https://geekexcel.com/wp-admin/post.php?post=16515&action=edit)
- **[Excel Formulas to Count Cells that contain either X or Y!!](https://geekexcel.com/wp-admin/post.php?post=16529&action=edit)**
A tip to declutter unused  cables with a tape writer and pouches
Tags: usb, lifehack, decluttering, minimalism
Published: 2020-10-31 11:49:40

I have a lot of unused cables put away in a drawer. Those are USB type-C cables, micro usb cables, lightning cables, thunderbolt cables, LAN cables, audio cables, etc.
I can no longer remember which type of cables I have. When I need a USB type-C to A cable but I have no idea where it is.
So I decided to organize them so that I can quickly use them.

![_DSF8155](https://dev-to-uploads.s3.amazonaws.com/i/a3cr5aohvy9mvwxf1ter.jpg)

These are not all the cables I have but they would be the ones that I will more likely use than others.
First off, I categorized them into groups based on types:

![_DSF8162](https://dev-to-uploads.s3.amazonaws.com/i/jb7xfi3i60jdhdltrttr.jpg)

I've got some mesh pouches that I bought at a 100-yen store (a Dollar store in Japan):

![_DSF8157](https://dev-to-uploads.s3.amazonaws.com/i/0l42xlg5rub4ryizyosx.jpg)

![_DSF8159](https://dev-to-uploads.s3.amazonaws.com/i/krtwn47m8fu9eyghca4z.jpg)

And here is a tape writer:

![_DSF8161](https://dev-to-uploads.s3.amazonaws.com/i/ybazjdx29mcq8gk0315o.jpg)

https://amzn.to/3oJUOkA

Are you getting it? I'm going to put my cables into these pouches and to label them.
You can make labels like so:

![_DSF8163](https://dev-to-uploads.s3.amazonaws.com/i/7muisyxtz1i5br0xsqlu.jpg)

I made labels for each cable type:

![_DSF8164](https://dev-to-uploads.s3.amazonaws.com/i/7odob5clbwmifki7ntvj.jpg)

And put them on top of the pouches:

![_DSF8166](https://dev-to-uploads.s3.amazonaws.com/i/ihwr4nt2wvot3704ferw.jpg)

Pretty neat! Now, you can quickly find cables.

![_DSF8167](https://dev-to-uploads.s3.amazonaws.com/i/qrofajj4iyel6g051b6z.jpg)

By putting the labels on top of the pouches, you can quickly find and access when they are in a drawer:

![_DSF8168](https://dev-to-uploads.s3.amazonaws.com/i/2xlegbvypr48t3k0avmu.jpg)

* * *

- Follow me on [Twitter](https://twitter.com/inkdrop_app) & [Instagram](https://instagram.com/craftzdog)
- [Inkdrop - Markdown note-taking app](https://www.inkdrop.app/)

[![Subscribe Newsletter](https://dev-to-uploads.s3.amazonaws.com/i/lo4tbclrb4fi1zoif0ui.png)](http://eepurl.com/dNgJo6)

[![My YouTube channel](https://cdn-images-1.medium.com/max/3000/1*r-daItizHpAU-fQZk3ISag.png)](https://www.youtube.com/c/devaslife)
Real-world opensource collaboration
Tags: opensource
Published: 2020-10-31 00:57:50

### Summary
[Issue](https://github.com/ritwik12/Celestial-bodies-detection/issues/73)
[Pull request](https://github.com/ritwik12/Celestial-bodies-detection/pull/74)
I made some small changes to the documentation

### Details
This was the first time I tried to work on non-student opensource project, so I aimed for something small and simple (exactly like documentation). The repo was about AI recognition of pictures of "space object". It sounded nerdy so I like it.
They posted an issue to extend the document for more human-known "space object". I have to read a little bit about space, there are many type of objects so I only add something that regular people care about. I also read their whole document and fixed some misinformation. My pull request got approved one day after submission and they thanked me for correcting mistake.
In the future, I will probably enjoy documentation but only if the topic are interesting enough (or nerdy enough). Otherwise, I would prefer more coding.
Easy slick slider - wordpress plugin 
Tags: wordpress, php, html, javascript
Published: 2020-10-31 11:14:36

- Custom types are supported, and you can define which one you will use
- You are able to choose what categories or terms you want to show.
- You are able to choose the taxonomy you want to use for your slider.
- This slider is responsive and you can manage the number of the items that will be shown on large, medium, and small screens.
- You are not limited by the number of sliders per page.
- You can use order by taxonomies and terms together as well.

Short video: https://www.youtube.com/watch?v=01neI1mfVJY&feature=emb_logo

Everything that you need is to use the shortcodes like on examples below:

```
[cs_slick_slider_all post_type="post" post_number="10" swipe="false" responsive="large=5,medium=3,small=1,exsmall=1" show_description="true"]

[cs_slick_slider_all post_type="project" taxonomy="project_cat" terms="10,14,16" post_number="10" swipe="false" ]
```

PRO version: https://conic-solutions.com/wp-plugins/slick-slider-all/

Freemium version: https://wordpress.org/plugins/slick-slider-all/
API design for code quality
Tags: apidesign, codequality
Published: 2020-10-31 11:03:34

---
title: API design for code quality
published: true
description: Designing internal API's is hard for lack of data 
tags: apidesign,codequality
---

I so appreciate a thoughtful API. Working with a great API feels like using a super power: I'm productive, feeling good about the quality of the code I write, and just _happy_.

Designing a good API is hard work. Above all it requires data about different things people want to do with the API. The more the better. Such data provides an objective measure of how useful the API is.

I'm often tempted to create internal API's, hoping it will bring productivity and joy to working in part of the code. This is hard when the small group working with the code don't produce enough data to support good API design.

Which isn't to say we should give up on code quality, just that API design might often not be the right approach. When writing code used by a small group of people techniques like data modeling can achieve better results.
My Experience with HacktoberFest 2020
Tags: hacktoberfest
Published: 2020-10-31 11:00:55

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->


### 🌴 About me
Hi I'm Harshit, a self learning computer science beginner who likes creating stuff. 🐢
I joined this beautiful Dev community, It is filled with awesome resources and people who write articles and I also want to share my experiences, cool resources and solutions of some problems.

### 📜 Background
I'm new to this open source community, have been working on some opensource projects since july 2020 :)

### 🐇 Progress
My brother advised me to start learning about open source contribution and he was the person who shared me this awesome HacktoberFest opportunity...and i actually learned a lot about open source stuff and also completed the hacktoberfest.  

### ✨ Contributions

<!-- This is where you can list the contributions you made and explain why you chose the projects you did. Don’t forget to add links!  -->
since I'm a beginner I started with some basics (beginner friendly repos)...here is the list of contributions I have made :

#### 1. [cloud haiku](https://github.com/do-community/cloud_haiku) :

This repository is made by digital ocean organisation where you have to write a unique haiku by yourself.

#### 2. [First bit](https://github.com/BitByte-TPC/first-bit) :

First-Bit is also a beginner friendly repo which teaches you the fork -> clone -> edit -> PR workflow.

#### 3. [code for cause](https://github.com/codeforcauseorg/pledge) :

Another beginner friendly repo to take pledge to code for cause.

#### 4. [First Contributions](https://github.com/firstcontributions/first-contributions) :

A repo with basic tutorial on how to get started with opensource contribution.

### 🎀 Reflections
<!-- Overall, how has your Hacktoberfest 2020 experience been? If you’re a first-timer, will you participate again? What have you learned? Have you made any interesting connections? What is your next step in open source?  -->
Overall the experience was nice and exciting. This was my first time participating in hacktoberfest, It helped me a lot in expanding my knowledge about opensource. I'll participate again next year and will try to do some more high quality contributions.
How to reduce the file size of Tailwind CSS using PurgeCSS?
Tags: tailwindcss, css, purgecss, tutorial
Published: 2020-10-31 10:49:44

Tailwind CSS is a popular utility-first CSS framework used by hundreds of thousands of web developers all over the world. The new methodology of working with classes and styles can make building user interfaces easier and faster. In this guide you will learn how to reduce the final size of the Tailwind CSS file by using PurgeCSS and make your website load faster.

By default, the uncompressed file size of Tailwind CSS is 2413.4kB, minified it is 1967.4kB, minified and compressed using Gzip it’s 190.2kB, and when compressed with Brotli it’s 46.2kB. In comparison, the uncompressed file size of Bootstrap CSS is only 143kB. So you might ask, why is it so large? Can I reduce the size of it? The answer is yes, definitely!

## Why is the default file size of Tailwind CSS so large?

[Tailwind CSS](https://tailwindcss.com/) is a collection of utility classes to set certain values of margins, paddings, font sizes, font weights and many more using classes directly. Instead of adding extra padding to a button using a class such as `.button`, you only need to add the class `.p-3` or `p-4` and you’ll add padding directly to the element.

The downside is that there are thousands of these utility classes in Tailwind CSS and most of them are not even used in the project and the default size of Tailwind CSS is fairly huge compared to other CSS frameworks. But this does not mean you shouldn’t use Tailwind CSS for your projects, because there is a pretty easy solution to all of this.

## How to reduce the file size of Tailwind CSS?

All you need to do to reduce the file size of Tailwind CSS is to remove all of the unused utility classes from the main CSS file. Of course, you shouldn’t do that manually, because there is an awesome tool called PurgeCSS that goes through your HTML templates and decides which CSS classes are used and unused and based on that remove the unused ones from Tailwind CSS.

I assume that you already have a working Tailwind CSS project set up and that you are using the `tailwind.config.js` file and not only the CDN. If not, check out our latest [Tailwind CSS Tutorial](https://themesberg.com/blog/tailwind-css/tutorial) where you can learn how to use Tailwind CSS in the recommended way.

### Configure PurgeCSS in your Tailwind configuration file to remove unused CSS

All you need to do is provide the paths that [PurgeCSS](https://purgecss.com/) should look for in your `tailwind.config.js` file by adding the following properties to the `purge` object:

```
// tailwind.config.js
purge: {
    enabled: true,
    content: [
        './**/*.html'
    ]
}
```

If you run the build command to process the configuration file you will see that the compiled CSS file of Tailwind CSS will be much smaller than the default size, because the unused classes have been removed.
Automated Visual Regression Testing
Tags: testing, tutorial, javascript, devjournal
Published: 2020-10-31 10:27:23

As Hacktober is nearing to an end, you might like another area to challenge yourself at. How about improving the reliability of your UIs? Automatically! 

I wrote some scripts to look over the changes I make. Here I'm sharing [the tutorial](https://joannaerd.medium.com/automated-visual-regression-testing-1b542263916d) on how to achieve the same result.

Bring your Jest and Storybook and let's have a visual-regression-be-gone party! 🍿💻🍭
Hacktoberfest
Tags: android, kotlin, hacktoberfest
Published: 2020-10-31 08:33:57

Finally submitted my hackoberfest 4th PR!

https://www.github.com/theDroidCamp/List_Of_Data/tree/master/app%2Fsrc%2Fmain%2Fjava%2Fcom%2Fnoelon%2Flistofdata
1/100 days of code
Published: 2020-10-31 10:04:43

---
title: 1/100 days of code
published: true
description: getting started
tags:
cover_image: https://res.cloudinary.com/studiobanauso/image/upload/v1604441163/100daysofcode/100days_01.jpg
---
Getting started on the project. A personal portfolio page for a graphical artist/ developer. 
So, could be for me or could be a template. We’ll see. 

It is based off of Wes Bos’ Gatsby course. In order to get started quickly, I am using his starter files to lay out the base of the page. 

I like the course and am following along and this project is going to be a transfer of what I learned.
Firefox address autofill
Tags: firefox
Published: 2020-10-31 10:03:15

This might be news for some, but [Firefox](https://www.mozilla.org/en-GB/firefox/new/) does not have all the features available for all the geographical locations. The reason for this is nothing malicious I would say, it's simply because [i18n is hard](https://hitchhikers.fandom.com/wiki/Babel_Fish).

So I was quite surprised to learn that there is no address autofill available in my Firefox installation. Something so convenient I can't imagine using web browser without it.

After a little bit of research I found a lot of outcries [[1](https://support.mozilla.org/en-US/questions/1261333),[2](https://support.mozilla.org/en-US/questions/1220110),[3](https://support.mozilla.org/en-US/questions/1280758)] on the Mozilla support forum, some generic help pages that briefly mentioned that this feature is US only [[4](https://support.mozilla.org/en-US/kb/automatically-fill-your-address-web-forms)] and finally a little bit more useful wiki with proper breakdown of the feature availibility [[5](https://wiki.mozilla.org/Firefox/Features/Form_Autofill#Feature_Availability)].

So the way to enable form/address autofill for non-US country is:

1. Put into address bar `about:config` and click **Accept the risk and continue**
2. Search for following and set:
  - `extensions.formautofill.available`: `on`
  - `extensions.formautofill.creditCards.available`: `true`
  - `extensions.formautofill.supportedCountries`: `GB` (this settings depends on where **you** live - check [ISO 3166](https://dev.maxmind.com/geoip/legacy/codes/iso3166/))
3. Restart firefox
4. Check on the [somewhat official Firefox address autofill demo](https://luke-chang.github.io/autofill-demo/) that the feature works for you

![Firefox address autofill](https://dev-to-uploads.s3.amazonaws.com/i/iyt7uk5qzy1f27aeyab8.png)
Drash's Performance Improvements
Tags: deno, typescript, webdev, drash
Published: 2020-10-31 06:29:49

Soon, Drash will perform faster than ever. Although this is still a work in progress, Drash's codebase is being reworked to handle the workload of a VERY LARGE application. As a result, your Drash apps will perform faster than they currently do.

What this means is, for a Drash server with thousands of resources, it can handle up to ~284k requests in 10 seconds (or ~28.4k req/sec). For example, if up to ~28.4k people visited a website powered by Drash at the same exact time, they would all see the website load within 1 second. Due to this, it shows Drash is more than capable of handling the load for small and VERY LARGE web applications, whilst maintaining great performance. You can follow the progress of Drash's performance improvements at https://github.com/drashland/deno-drash/pull/393.

Machine Details:

MacBook Pro (Mid 2015), 2.5 GHz Quad-Core Intel Core i7, 16 GB 1600 MHz DDR3

As always, keep developing with confidence, friends!

(Join the community at https://discord.gg/6XkVDE)
Hacktoberfest 2020 Challenge completed!
Tags: hacktoberfest
Published: 2020-10-31 09:20:39

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->


### About Me

Hello, I am Pappu Kumar Currently Working as a part-time SDE employee t Canada Base Company


### Progress

Finally, I won the Hactoberfest 2020.🤩

### Contributions

Most of the projects are great where I contributed


### Reflections
It's a Great Experience
Hacktoberfest 2020 Challenge completed!
Tags: hacktoberfest, opensource, github
Published: 2020-10-31 08:39:56

✨Well, this was my first open-source contribution and I was really excited to be a part of this year's hacktoberfest. After successfully contributing to the open-source community it feels really amazing. ✨ 

 I am an Under-Grad Student at Graphic Era University, pursuing a Bachelor's in Computer Science. I love to learn and contribute in any and every possible way.  

I used to see hacktoberfest name all over my feed on Linkedin and only through Linkedin I got to know about this awesome event.

### Reflections
This was my first time participating in hacktoberfest and after successfully completing this event, it feels really amazing. And I am eagerly waiting to participate again in next year's hacktoberfest.

 @DigitalOcean