How To Use Excel COUNTIFS With Multiple Criteria And OR Logic || Excel Tricks || dptutorials
In this tutorial let us see How To Use Excel COUNTIFS With Multiple Criteria And OR Logic
Click here to download the excel workbook: https://drive.google.com/file/d/1Flak...
We all know that we use the countifs function to count values matching with multiple criteria.
By default this countifs function considers the AND logic only. But what if you want to match with OR logic.
Let us see this by considering an example like this.
This is the sample data where I have entries with different statuses like this
and let me try to count the entries matching the criteria here on the right side.
1st let me count the entries whose status is “Complete”. I type the formula in cell G5 as
= COUNTIFS($C$5:$C$12,”Complete”) and enter to see the result as 3.
And the let me count the entries whose status is “In Progress”. Type the formula in cell G6 as
=COUNTIFS($C$5:$C$12,”In Progress”) and enter to see the result as 2.
Now, observe carefully. If we want to count entries whose status is either complete or in-progress.
We generally add both the above two results. But there is a formula to do this, type the formula in cell G7 as
=SUM(COUNTIFS($C$5:$C$12,{"Complete","In Progress"}))
And press enter to see the result as 5 which is nothing but the sum of above two results.
Got it friends.
So friends, in this way One can Use Excel COUNTIFS With Multiple Criteria And OR Logic
I hope you have enjoyed this tutorial, If yes, please do give me a like, share and comment.
For further more interesting videos, please do subscribe dptutorials.
For Personalized detail learning, write to [email protected]
If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.
***********************************************
★ My Online Tutorials ► https://www.dptutorials.com
LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources
Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2
Support the Channel via shopping: http://ift.tt/2jH38PR
Tools that I use for Vlogging:
• Laptop: http://fkrt.it/AM9ab_uuuN
• Canon 200D Camera: http://fkrt.it/AMz75_uuuN
• Benro Tripod: http://fkrt.it/An1lm_uuuN
• Microphone: http://fkrt.it/A2RHz_uuuN
• Collar Microphone: http://fkrt.it/yL8kdQNNNN
• Screen recorder: https://techsmith.pxf.io/2BMjA
• Boom Arm Stand: http://fkrt.it/ypUD8QNNNN
• Zoom H1 Audio Recorder: http://fkrt.it/ypb7WQNNNN
• Harison Softbox Studio Lights: http://fkrt.it/ypCaRQNNNN
• Chroma Key Green Screen: http://fkrt.it/A3gnb_uuuN
• Background Support Stand: http://fkrt.it/A3cCb_uuuN
• Acoustic Foam Background: http://fkrt.it/ypsGdQNNNN
• USB RGB LED Strip: http://fkrt.it/A3T_5_uuuN
• Wireless Mouse: http://fkrt.it/A3Bqz_uuuN
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
***********************************************
You Can Connect with Me at:
YouTube: / dptutorials
G+: http://ift.tt/2kAOpa6
Twitter: / dptutorials15
Facebook: http://ift.tt/2kfRnDi
BlogSpot: http://ift.tt/2kB14dh
Follow:
www.dptutorials.com
www.askplanner.blogspot.com
#dptutorials #exceltricks #excellearning #exceltutorials #exceltraining #exceltips
Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in English,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel training,attendance sheet in excel,excel data entry,excel formulas and functions,microsoft excel 2007, ms excel tutorial, excel formulas, and functions in hindi, excel formulas and functions tutorial, excel formulas in english, excel formulas in
Watch video How To Use Excel COUNTIFS With Multiple Criteria And OR Logic || Excel Tricks || dptutorials online without registration, duration hours minute second in high quality. This video was added by user dptutorials 20 March 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 51,148 once and liked it 463 people.