teleren/devto huggingface dataset:
Excel formulas for Counting Cells that Match Two Conditions in Excel 365!!
Tags: excelformula
Published: 2020-10-14 11:48:43

---
title: Excel formulas for Counting Cells that Match Two Conditions in Excel 365!!
published: true
date: 2020-10-13 12:05:38 UTC
tags: ExcelFormula
canonical_url: https://geekexcel.com/excel-formulas-for-counting-cells-that-match-two-conditions-in-excel-365/
---

## Formulas for counting Cells that Match Two Conditions in Excel Office 365:

In this article, we will show the Formulas for Counting Cells that Match Two Conditions in Excel Office 365. 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)
## Formula Syntax:

The below formula is used for Counting Cells that Match Two Conditions in Excel Office 365.

**=COUNTIFS(B2:B10,”>40″,C2:C10,”F”)**

### Example:

- The below screenshot will show the detailed view of how to count the cells that match two conditions in Excel Office 365 using formulas.
- In this image, we will give the input name in **Column A**.
- And other details like age and gender are given in **Column B** , **Column C** respectively.
- Now apply the formula after that, it will get the result in a selected column as below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/ma10.png)

## Syntax Explanations:

**COUNTIFS** – The Excel COUNTIFS Function is mainly used to count cells that meet one or more criteria.

## Verdict:

From this article, you will learn how to use the **formula to count cells that match two conditions in Excel Office 365**. If you know more formulas, drop it in the below **comment** box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!
Formulas for Counting Cells with Multiple OR Criteria in Excel 365 !!
Tags: excelformula, excelformulas
Published: 2020-10-14 11:48:29

---
title: Formulas for Counting Cells with Multiple OR Criteria in Excel 365 !!
published: true
date: 2020-10-13 12:03:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-cells-with-multiple-or-criteria-in-excel-365/
---

## Formulas for Counting Cells with Multiple OR Criteria in Excel:

In this tutorial, we will guide you to learn the formulas for **Counting Cells with Multiple OR Criteria in Excel Office 365**. 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)
## Formula Syntax:

To Count Cells with Multiple OR Criteria in Excel Office 365, use the below formula.

**=COUNTIF(B2:B10,”27″)+COUNTIF(B2:B10,”<23″)+COUNTIF(B2:B10,”>50″)**

### Example:

- In the below screenshot, we give the input range in **Column A** , age, and gender are given in **Column B** and **Column C**.
-  The age limit is given in **Column E** as shown in the image.
- After applying the formula we will get the result in selected **Cell F2** as shown in the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/ma5.png)

## Syntax Explanation:

- **COUNTIF** – In Excel, the main purpose of the **COUNTIF** Function is to count cells in the range that matches the single condition or criteria.

## Wind Up:

In this article, you can get to know the formula for **Counting Cells with Multiple OR Criteria in Excel Office 365**. Kindly, drop your valuable feedback in the below **comment** section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!
Excel Formulas for Counting Comma Separated Values in a Single Cell !!
Tags: excelformula, excelformulas
Published: 2020-10-14 11:48:14

---
title: Excel Formulas for Counting Comma Separated Values in a Single Cell !!
published: true
date: 2020-10-13 12:01:28 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-for-counting-comma-separated-values-in-a-single-cell/
---

## Formulas for Counting Comma Separated Values in Single Cell:

This page shows the list of formulas for **Counting Comma Separated Values in a Single-Cell in Excel 365**. 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)
## Formula Syntax:

The simple formula to Count Comma Separated Values in a Single Cell in Excel 365 is given in below.

**=[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)([TRIM](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/)(B3))-LEN([SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/)(TRIM(B3),”,”,””))+1**

### Example:

- In the below screenshot, we give the input text strings in **Column B.**
- After applying the formula, we can get the result in  **Cell D3** as shown in the image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/ku13.png)

## Explanations for the Syntax:

- **LEN** – This function is used to calculate the length of the text strings in the Excel Office. For more details about [LEN Function](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/).
- **TRIM** – The main purpose of this function is to remove the extra spaces from the text. Read more on [TRIM Function](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/).
- **SUBSTITUTE** -The Excel [SUBSTITUTE Function](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/) can replace existing text with a new string in a text string.

## Closure:

In this article, you will learn the easy method for using a **Formula to**  **Count Comma Separated Values in a Single Cell in Excel Office 365**. If you found this article is useful to you, then kindly drop feedback in the below **comment** section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!
Daily Developer Jokes - Tuesday, Oct 13, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-10-13 12:00:11

---
title: "Daily Developer Jokes - Tuesday, Oct 13, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Tuesday%2C%20Oct%2013%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e1258a63bab5.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
___Q:___ What did the array say after it was extended?

___A:___ Stop objectifying me.
 -->
Not relying on KDE Plasma to correct monitor layout
Tags: linux, tutorial, bash
Published: 2020-10-13 11:52:05

## Summary

- KDE Plasma seems to forget the setting for monitor layout at certain event. I lost the setting while I was investigating about how I can avoid my X1E2 to get crashed with an extra monitor when turning on vsync to play a game.
- This corrects the monitor layout issue.
- My X1E2 has 1920x1080 and the external monitors have 2560x1440.

## Scripts

```
/usr/local/bin/layout-monitors
====================
#!/bin/bash

xrandr \
  --output DP-0 --auto --size 2560x1440 --panning 2560x1440 \
  --output DP-1 --auto --pos 2560x0 \
  --output eDP-1-1 --auto --primary --pos 640x1440
```

```
/usr/share/sddm/scripts/Xsetup
====================
#!/bin/sh
# Xsetup - run as root before the login dialog appears

if [ -e /sbin/prime-offload ]; then
    echo running NVIDIA Prime setup /sbin/prime-offload
    /sbin/prime-offload
fi

# Important: Put at last because it does not work otherwise
# ===== FROM HERE =====
if [ -e /usr/local/bin/layout-monitors ]; then
    echo running layout script /usr/local/bin/layout-monitors
    /usr/local/bin/layout-monitors
fi
# ===== TO HERE =====
```

## Original Post

[Here](https://www.reddit.com/r/X1ExtremeGen2Related/comments/gnc5wf/not_relying_on_kde_plasma_to_correct_monitor/)
Active Inactive Status Using Toggle Button/Slide laravel 8 
Tags: laravel, html, css
Published: 2020-10-13 11:43:43

Almost require to create an active inactive functionality in laravel. it might be required for user status, product status, category status, etc. we have always enabled or disabled, active and inactive, etc. you can do it this toggle status active inactive PHP example this time.

**[Active Inactive Status Using Toggle Button/Slide laravel 8 ](https://www.phpcodingstuff.com/blog/active-inactive-status-using-toggle-buttonslide-laravel-8.html)**
Wandr - Video-sharing community for travelers
Tags: android, ios, startup
Published: 2020-10-13 11:37:11

Hello dev.to community! Thanks for taking the time to check out Wandr. We have just released our beta version and are looking to gather videos and feedback to make this product more helpful for travelers!

At Wandr, our vision is to bring you closer to the world. We want to take travelers from travel inspiration to dream destinations as easily as possible. Social media inspires millions of travelers every year, but it doesn't allow them to plan and book travel. We are trying to solve the inspiration disconnect that exists on traditional social media platforms (Instagram vs reality, one might say), and provide a solution for travelers to book and save the experiences they see on social media.

Since traveling has been paused for many people, we wanted to create a product where travelers could relieve their past experiences, while simultaneously inspiring and helping others plan their next trip. By swiping through a feed of videos of your dream destination, and saving the ones that interest you, you can create a trip plan without the headache of visiting 100+ websites before booking.

iOS: https://apps.apple.com/app/wandr/id1526488140
Android: https://play.google.com/store/apps/details?id=com.wandrnow.app

Looking forward to hearing your feedback!
Pass AWS Certified Cloud Practitioner in a week
Tags: aws
Published: 2020-10-13 11:28:15

I'm sharing here my experience on pass AWS CCP certification, here are few things i would like to share to get you certification.

Course
- AWS training 
  - https://aws.amazon.com/training/course-descriptions/cloud- 
    practitioner-essentials-classroom/
  - https://aws.amazon.com/training/course-descriptions/cloud- 
    practitioner-essentials/
- AWS Whitepapers
  - https://d1.awsstatic.com/whitepapers/aws-overview.pdf
  - https://bit.ly/2FpuIBx
- freeCodeCamp
  - https://www.youtube.com/watch?v=3hLmDS179YE
- A Cloud Guru
  - https://acloud.guru/learn/aws-certified-cloud-practitioner
- Udemy 
  - https://www.udemy.com/course/aws-certified-cloud-practitioner-new
- Salesforce Trailhead
  - https://sforce.co/3dmGlWa


Practice Questions
 - Udemy (https://www.udemy.com/course/aws-certified-cloud-practitioner-practice-test/)


Before the exam day, make sure you go through aws whitepapers.

All the best :)
NEED HELP IN FINAL YEAR PROJECT (FYP)
Tags: python, node, javascript, security
Published: 2020-10-13 11:26:03

Hey, I need help in a Final Year Project. I have to create a CMS (Login, signup, Checking Marks, bills) for a University. Now I am confused about which technology to use at the Backend Python Django or NodeJs. 

Front-end = REACT.

Keep in mind that, I am planning to go into Cyber Security or ML Field.
Does 'not using Chrome' to you also mean 'not logging-in to any Google services'?
Tags: webdev, discuss, browser, security
Published: 2020-10-13 10:32:33

---
title: Does 'not using Chrome' to you also mean 'not logging-in to any Google services'?
published: true
description: 
tags: webdev, discuss, browser, security
cover_image: https://www.cyclonis.com/images/2018/03/chrome-password-generator-secure-password.jpg
---
Once in a while, a new post on migrating away from Chrome appears here and there across the blogging platforms.

The reasons for that surely may vary from person to person, but one of the main tendencies I've noticed are concerned with possible privacy issues.

Let's say you start fresh with Firefox, Brave, or another browser.
The first roadblock you may face is to log-in to your G-mail account to access your email or sign in to YouTube to access your account. Also, chances are you are still gonna use the Google search engine. 

How do you deal with this? Does migrating away from a particular browser affect your use of side services as well?
Talking CI/CD and containers on the Docker Live Show
Tags: docker, devops, cicd, kubernetes
Published: 2020-10-13 10:24:57

---
title: "Talking CI/CD and containers on the Docker Live Show"
published: true
description: "Watch Bret Fisher and me discuss container CI/CD on the DevOps and Docker Live Show (Ep 97)"
tags: docker, devops, cicd, kubernetes
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/ezetjwoyh7obh50e604x.png
---

I'd like to share with you a video of me being a guest at [Bret Fisher's Docker Live show](https://www.youtube.com/c/BretFisherDockerandDevOps) which I think was a great discussion.

The questions were pouring in from the start so the entire episode had a great flow.

Some of the things we've discussed:

- The origins of Semaphore
- Git & GitHub flow
- The _[CI/CD with Docker and Kubernetes](https://dev.to/semaphore/new-ebook-ci-cd-with-docker-and-kubernetes-4op0)_ book
- The importance of automated tests and how to get started
- How to set up and optimize [CI/CD pipelines](https://dev.to/markoa/ci-cd-pipeline-a-gentle-introduction-2n8k) when using Docker
- Semaphore's Workflow Builder as a way of making CI/CD more accessible to developers
- ...and more!

Watch it — and let me know if you have any questions or feedback:

{% youtube 1cL4c4edkFM %}
Store Cryptocurrency on the safest wallet Ledger
Tags: blockchain, crypto, xdc
Published: 2020-10-13 10:24:50

A hardware wallet is a #cryptocurrency wallet which stores the user's private keys critical piece of information used to authorise outgoing transactions on the #blockchain network in a secure hardware device.

Learn how to use #Ledger NanoS with #XDC Network: https://medium.com/xinfin/how-to-use-ledger-nano-s-with-xdc-network-5d3048401374
Unique Gaming Glasses, Syght Gaming Glasses - Syght Glass
Published: 2020-10-13 10:12:11

 very interesting , good job and thanks for sharing such a good blog.Improve quality of your vision with best gaming glasses from Syght Glass. Buy online best gaming glasses with blue light blocking technology and UV protection. #high-quality #Fast-shipping #low-price.https://www.syghtglass.com/collections/gaming-glasses
Six Reasons Why You Should Select Android for Developing On-demand Apps
Tags: discuss, android, ios, devops
Published: 2020-10-13 09:49:38

With over 3.6 million apps in Google Play across various genres, Android OS enjoys a lion’s share in the mobile app market. Recent updates of this amazing platform have kept the focus on the app’s security and enterprise-friendly features along with performance improvements. As a result, today, there are around 125 million Android users in the USA, which was once considered as Apple’s stronghold. As per Statista expectation, this number will cross 130 million by the year 2021.

The rise of the Android robot has attracted entrepreneurs and mobile app developers across the world. Even startups and SMEs also tend to prefer Android OS to come up with their first app. In this blog, we will show the importance of Android OS from the perspective of a mobile app development company. These days, on-demand app development is thriving, and we will make a list of eight strong reasons why you should opt for Android to build a customized on-demand app.

But before that, let’s discuss the rise of on-demand apps.

Why on-demand apps are much in demand?            

Amid the lockdown-like situation globally, people prefer to get groceries, food items, and other household products at their doorstep. It is a major reason behind the rise of the on-demand apps. Today, advanced and feature-rich on-demand apps not only make the user’s life easy but also meet the diverse requirements of food and other items.
How to reduce bug fixing time for php, by 15%
Tags: php, webdev, beginners
Published: 2020-10-13 09:12:51

It's really simple guys
<--just say this php pre-code prayer-->
Our dear php who art in binary,
hallowed be thy typesystem,
thy monoids come,
thy will be done on vscode as it is in phpstorm,
give us this day our daily recursion,
and forgive us of our long functions and infinite loops,
lead us not into imperative languages,
but deliver us from useless checks and unnecessary catsings,
for thine is thy type system the classes,
the objects and the pure functions,
forever and ever.
in the name of :
array_filter
array_map,
and array_reduce 
Amen.
I RECOMMEND ADDING IT TO YOUR NEW PROJECT 
tell me how it goes
10 Ways to Fix NET::ERR_CERT_AUTHORITY_INVALID Error Permanently
Tags: googlecloud
Published: 2020-10-13 09:38:26

Are you struggling with the NET::ERR_CERT_AUTHORITY_INVALID due to don’t have an SSL certificate or if the certificate are not updated or the browser doesn’t recognize the validity of the certificate, then read the article to follow the fixes @ https://www.pcerror-fix.com/net-err-cert-authority-invalid-error
Why should you choose Salesforce?

Tags: salesforce
Published: 2020-10-13 09:19:18

**Salesforce - What is it?**
Have a clear idea of   what Salesforce is like or what it's for? Well, Salesforce is a cloud-based [CRM software](https://www.cloudanalogy.com/), which helps companies optimize all dispersed business processes and grow in a more organized way. It has been available in the market since the late 90s and over time it evolves and becomes one of the most complete, efficient and creative CRM solutions capable of covering all the needs of your business.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/xg8pdziqa4odw546uhdd.jpg)

**Reasons to choose Salesforce**

Here is a list of compelling reasons why this CRM solution is so popular these days and why it deserves your consideration and attention.

**> Cloud-based**
In terms of flexibility, [Salesforce](https://www.cloudanalogy.com/) would give you higher-level benefits. Use it from anywhere, anytime! This CRM's advanced and secure cloud infrastructure offers unique cloud solutions for marketing, sales, analytics, and support.

**> Easily customizable**
Do you want to add additional fields or modules to your CRM solution according to your business expansion? You can do all of these things easily with one click!

**> Easy to use**
Wondering how to work with this new CRM?  Just connect from anywhere, communicate with your colleagues, update and view customer data anytime you prefer. Yes, it is so easy to handle.

**> Multi-tenant platform**
One of the biggest benefits of using this CRM platform is getting the latest features with automatic and seamless updates three times a year. All Salesforce users share the same CRM software instance and infrastructure. This is the reason why all users receive simultaneous and automatic updates while securing all the data they contain.

**> Efficient reports**
You will get powerful reporting tools available on this platform. These tools will not only help you save money and time, but will also help you get detailed business analysis. You can customize the reports. In addition, you will benefit from real-time reporting and analysis capabilities, as well as contract management.

**> AppExchange Ecosystem**
This is one of the business benefits you can enjoy with Salesforce. You can design and market your own application using it. More interestingly, you can get access to a handful of safe, verified, and helpful apps and integrations created by other [Salesforce](https://www.cloudanalogy.com/) users.
10 Websites that offer free HTML & CSS templates! [Bookmark now]
Tags: html, css, webdev
Published: 2020-10-13 09:06:16

This post is based on the below tweet

<blockquote class="twitter-tweet"><p lang="en" dir="ltr">15 Websites that offer free HTML &amp; CSS website templates:<br><br>🧵👇🏻</p>&mdash; Sunil Kumar (@sunilc_) <a href="https://twitter.com/sunilc_/status/1315713705397555200?ref_src=twsrc%5Etfw">October 12, 2020</a></blockquote> <script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>

# 1. [HTML5UP](https://t.co/VmAFs2xEUO?amp=1)

![image1](https://pbs.twimg.com/card_img/1313848759147802625/YJ3L8ck3?format=jpg&name=small)

# 2. [TemplateMO](https://t.co/hCVsSqg3dx?amp=1)

![image2](https://pbs.twimg.com/card_img/1315253461244575744/RvqNfGpC?format=jpg&name=240x240)

# 3. [StyleShout](https://t.co/AeNAAvmiYx?amp=1)

![image3](https://pbs.twimg.com/card_img/1315711745336332288/UUfnGaoI?format=png&name=360x360)

# 4. [Start Bootstrap](https://t.co/kXGcIDRfoU?amp=1)

![image4](https://pbs.twimg.com/card_img/1313696626205061120/a1zFysOV?format=png&name=240x240)

# 5. [Zerotheme](https://t.co/WZtbW1gZzv?amp=1)

![image4](https://pbs.twimg.com/card_img/1314002652573896706/LOhu9UvP?format=jpg&name=240x240)


# 6. [Hubspot](https://t.co/T2jAlXYH8E?amp=1)

![image4](https://pbs.twimg.com/card_img/1313815306377342977/inUQIv89?format=jpg&name=360x360)

# 7. [OnePageLove](https://t.co/maFVlFMpuW?amp=1)

![image4](https://pbs.twimg.com/card_img/1313847267107893249/fDc1oXVJ?format=jpg&name=small)

# 8. [Themes for App](https://t.co/qiwmmHrWyX?amp=1)

![image4](https://pbs.twimg.com/card_img/1314602180880596993/trCZFLeR?format=jpg&name=360x360)

# 9. [Tooplate](https://t.co/INDaqk1OgD?amp=1)

![image4](https://pbs.twimg.com/card_img/1315401503130169344/pfeYalfl?format=jpg&name=240x240)


# 10. [Udeck](https://t.co/m6ab4hCzNb?amp=1)

![image4](https://pbs.twimg.com/card_img/1313766288385339392/VvrzAAU9?format=jpg&name=small)