Skip to main content

How to use COUNTIF and COUNTIFS in Microsoft Excel

In this Video You can learn How to use COUNTIF and COUNTIFS in Microsoft Excel 

Topics Covered:

 a) Count how many times a certain string or number appear in a list 

b) Count how many times multiple items appear in a list c) Count how many items are greater than or less than a certain value 

d) Count how many items are between certain values 

e) Count how many items do not match certain values f) Count how many items begin or end with certain characters 

g) Count how many items match certain conditions across multiple columns

https://youtu.be/mdURBPoE22U

Comments

Post a Comment

Popular posts from this blog

DONT BUY ALEXA!!!... CREATE YOUR OWN USING PYTHON|PROJECT|PYCHARM|

 Any Alexa Lovers???... Then this project is for you, create your own alexa by using Python.. by using 3 simple packages we can create own voice assistant, Packages are... 1. pip speech recognition 2. pip text to speech recognition 3. pip PyAudio IMPORTANT: IN SOME SYSTEMS PYAUDUIO, INSTALLATION PROBLEM OCCURS, IN THAT CASE, CHECK YOUR PYTHON VERSION, USE PYTHON 3.6 OR ABOVE. You can search the things, playmusic, and you can ask the funny question to alexa using below code.. import speech_recognition as sr import pyttsx3 import pywhatkit import datetime import wikipedia import pyjokes listener = sr.Recognizer() engine = pyttsx3.init() voices = engine.getProperty('voices') engine.setProperty('voice', voices[1].id) def talk(text):     engine.say(text)     engine.runAndWait() def take_command():     try:         with sr.Microphone() as source:           ...
Post a Comment
Read more

Create Your Own Browser Using Python | Python Project | PyQt5

This post is about Create Your Own Browser Using Python | Python Project | PyQt5, how to create a basic browser, by using Python, it so simple and easy to create, sometime browser which you're using may get slow down, that time you can use this browser. You may use this as mini-project for UG Programmes.   For Video Tutorial     Subscribe the Blog For More Updates: ______________ SOURCE CODE ______________ import sys from PyQt5.QtCore import * from PyQt5.QtWidgets import * from PyQt5.QtWebEngineWidgets import * class MainWindow(QMainWindow):     def __init__(self):         super(MainWindow, self).__init__()         self.browser = QWebEngineView()         self.browser.setUrl(QUrl('http://google.com'))         self.setCentralWidget(self.browser)         self.showMaximized()   ...
Post a Comment
Read more

How To Download Money Heist Sticker

 Are You Money Heist Fan?? Do you want Money Heist Sticker??.. Then Follow the instructions below to get your Sticker. No Apps Required. 1. Open Whatsapp 2. Open Your Whatsapp Chat, Click On Emoji Icon. 3. Click On Sticker Option. 4. Click on Plus Icon. To add a new Sticker. 5. Now Add Your Money Hesit Sticker. 6. Now Click And Download.....!!!!
Post a Comment
Read more