COUNTIFS in Excel 2016 (Multiple Criteria, Date, Wild Card etc)

Рет қаралды 64,184

Күн бұрын

COUNTIFS in Excel 2016: Learn more about how to use multiple criteria for counting function.
Complete Excel Foundation Course: shop.presentation-process.com...
What is covered in this Excel tutorial:
==============
00:00 What is Countif Function
01:18 Criterion for the formula
02:38 Set up multiple criteria in cells for counting
05:22 Set up Comparison with Operators (less than, more than etc.)
07:28 How to set up date criteria for Countifs
08:33 Using wild card operators for Countifs
09:37 Update Count automatically when you add entries
Useful best practice to save time for results to be updated automatically when you add data.
Download Exercise File to follow along easily:
drive.google.com/file/d/1XGDd...
Note: Countifs function is available from Excel 2007 onwards.
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.

Пікірлер: 46

@Blossoms-jz4yf 12 күн бұрын

Thank you so much. Your tutorial helped me a lot.

@449lokesh 4 жыл бұрын

Excellent. All in one!!! This is what I was looking for. Thank you so much!!!

@911tennisgirl 2 жыл бұрын

EXCELLENT presentation skills and easy to understand for complex requirements!

@michaelbunting2474 4 жыл бұрын

Just what I was looking for! Thank you for presenting this video. Very educational.

@JesusHernandez-fk4iv 3 жыл бұрын

You have great presentation skills, your video helped me a lot, thank you!

@PresentationProcess 3 жыл бұрын

Glad to hear that!

@arunkumar2209 4 жыл бұрын

Got it what i was looking for.. Thanks for the video sir

@geeta581 3 жыл бұрын

Very useful in practicality mode.....Big Thumbs up

@lalitsiv 3 жыл бұрын

Very educational video.. just making one report considering two criteria and search and found your video and resolve my problem in few sec...☺☺☺☺☺

@ashiwayne3504 4 жыл бұрын

Very useful and well presented- thank u!!

@sadier4660 3 жыл бұрын

Exactly what I need to solve an issue in a excel. Thanks a lot for this well explained lesson

@ashokar9135 4 жыл бұрын

Excellent... This is what exactly i was looking for, come up with many more videos like this...

@fmatsveru 3 жыл бұрын

Great teacher! Thank you.

@tiffanybahian9824 4 жыл бұрын

Thank you so much for your help.

@tabassumshahid6015 3 жыл бұрын

Really an amazing method of teaching👍

@sinleong1979 4 жыл бұрын

Great explanation. 👍🏻

@rajanphadke 4 жыл бұрын

Very nicely explained -Thank you sir

@ajeshyadav107 3 жыл бұрын

very good way to make understand.. loved it

@PresentationProcess 3 жыл бұрын

Thank you so much 😀

@upendrakumar6789 3 жыл бұрын

It's awesome. I can pay for such videos. It's my first view on your channel and I've become your fan

@brahimaitoufkir6621 3 жыл бұрын

Thanks man

@telugurani736 2 жыл бұрын

Excellent sir 👍👍👍👍👍

@tones_2466 2 жыл бұрын

Thank uuu

@ashishrai3731 3 жыл бұрын

Mind Bubbling

@mpkelum5206 3 жыл бұрын

Excellent

@Martin_Sj 3 жыл бұрын

Thank you

@stephaniegautray9270 2 жыл бұрын

Thank you so much very clear explanation please what formula to use is I want to Count num of item sold on a list of 1000 items.. and to deduct it automatically from the stock🙏

@mevartson164 4 жыл бұрын

Thank you very much sir. Your video is very helpful. What happened if we delete or add new items it Will update or not?

@kannank9772 3 жыл бұрын

Nice

@Longliveicecream 3 жыл бұрын

👌

@ernestogruspe8364 3 жыл бұрын

I am working around countifs with multiple criteria but the situation is one criteria should be always constant - say in one cell it should be always extremely critical and the other cell should meet the criteria that can be either of the following: No successor, with potential successor, internal development. Like countifs A + B1 or B2 or B3 = Ans

@charchitshah362 4 жыл бұрын

Hey. What should I do if I have to find number of orders between 2 different dates by using countifs ?

@tomgreening9875 4 жыл бұрын

Simply have two entries for the two conditions that must be simultaneously satisfied, such as COUNTIFS(A2:A20,">2000",A2:A20,"=" or "

@mohsinaliansari3441 4 жыл бұрын

I have question hope you will guide While using date you actually counted "date occurence". Suppose that there was a date in which no sale was made i.e an empty cell against a date. Now i select a date range in which the date with no cell also fall in. How will i calculate the number of "sales" in a date range not number of "dates in a date range??

@tomgreening9875 4 жыл бұрын

Use the SUMIFS function on column D, with the same set of filter criteria. This will sum the sales in column D for the same rows selected by the COUNTIF logic.

@AVV733M 4 жыл бұрын

How do you count items in column B with column C, at the same time, counting how many times column B sold items in column D? Example based on the table: Segment Country Units Sold Government Canada = 2 2 Midmarket France = 1 1 I am having a hard time how it will work on my data. Thank you.

@SagarKumar-yr1xv 4 жыл бұрын

Same here, if you got solution for it, please inform me.

@tomgreening9875 4 жыл бұрын

If I understand what you are asking, you don't want a COUNT of sales, you want a SUM of sales. COUNTIFS counts how many rows meet the filter criteria. You want to add-up the sales in column D, based on the same criteria as used in the COUNTIFS examples. Do this using the SUMIFS function. The formula would be SUMIFS(D2:D20, xxx) where xxx is the same set of range/criteria conditions used by COUNTIFS

@bhakti3m 3 жыл бұрын

@@tomgreening9875 Thanks its very useful. I would like to ask criteria midmarket and mexico in this criteria I have sum of total sales like in your example mid* and mexico 2470+2470 = 4940 how does it works.

@misbackendfinbud6853 4 жыл бұрын

can we use countif and today function in same formula

@tomgreening9875 4 жыл бұрын

It seems to work fine with TODAY and NOW functions in the range being checked, but you need to be careful how you specify the data conditions. His cell reference approach works, but it can get tricky if you try to write the date conditions within COUNTIFs directly.