Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence

Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence

Innozant

3 года назад

100,397 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Srikrishna Kumar
Srikrishna Kumar - 30.09.2023 19:18

Very good my friend.

Ответить
Vikash kumar Pandey
Vikash kumar Pandey - 05.09.2023 20:43

Exquisitely taught sir ji..superb❤

Ответить
Jiten Kalam
Jiten Kalam - 04.09.2023 10:46

Great job sir very useful information 👍

Ответить
shiva ellandula vlogs
shiva ellandula vlogs - 17.08.2023 06:25

How to do distinct count with count if s I. E multiple criteria and get distinct count using count ifs please explain

Ответить
deva thandav
deva thandav - 13.07.2023 17:03

Very useful & informative video 👍

Ответить
Angel_preet❤
Angel_preet❤ - 09.07.2023 19:24

Countif lgakr text and number ek sath utha sakte???

Ответить
आपणी सरकारी स्कूल डसाणा खुर्द नागौर
आपणी सरकारी स्कूल डसाणा खुर्द नागौर - 07.07.2023 09:33

Sir मेरे पास एक एक्सेल की वर्क शीट्स में काफी शीट है लेकिन दूसरी शीट की range se countif function se value 0 bata raha hai iska kya soluation ya कोई दूसरा फंक्शन use कर सकते है
= Countif(' sheet1'!a1: a40,"सब्जी")
To value 0 aa raha hai
जबकी orignal me 12 baar hai।

Ответить
KaMaL kumar
KaMaL kumar - 02.06.2023 22:41

"<>*" yeh NOT TEXT aise COUNTIF se karne par agar koyi BLANK CELL rehga wo bhi count mein aa jayega... Isliye cells with number dhoondne ke liye COUNT lagana behtar hoga

Ответить
LALIT NEHRA
LALIT NEHRA - 31.05.2023 07:55

sir app suru se excel shikhna ha uska link provided kar do please

Ответить
shahzad siddiqui
shahzad siddiqui - 10.05.2023 12:29

bahuttt badhya concept tha sir

Ответить
Santosh Dengle
Santosh Dengle - 19.04.2023 20:51

Sir mera ek sawal hein
Mujhe Saturday and Sunday count karna hein par, condition e hien ki, hamare pass sirf Star date hein , end date nahiiiii, par dono ka count ek sath karna hein
Aap madat kar sakte hein

Ответить
M k Mandal
M k Mandal - 04.03.2023 04:17

Sir mere pass ak data hei. O data mei bohot company ka details hei.mujhe use ak company mei kitne log kam korte hein , unka salary nikalna hei to keise konu without search filter ak formula botaiye. Please 🙏🏻

Ответить
Ravi Chaudhary
Ravi Chaudhary - 25.02.2023 14:52

Bhai mujhe ek range m jitne unique h unka count chahiye unke samne

Ответить
Manoj Thakur
Manoj Thakur - 23.02.2023 16:52

I have a question pls

Ответить
Mu Shk
Mu Shk - 15.02.2023 13:05

He only knows how to bring results. Don't know how to explain in detail. He's trying to be over smart.

Ответить
Information & Information
Information & Information - 03.02.2023 19:44

How to freeze I can't understand

Ответить
waleed alqubati
waleed alqubati - 31.01.2023 00:55

With you I feel I understand Hindi also 🙏

Ответить
irfan hassan
irfan hassan - 21.01.2023 10:11

Hi sir, less than and equal to , what criteria will i use?

Less than 4 and equal to?

Ответить
irfan hassan
irfan hassan - 21.01.2023 09:54

Hi sir, i have one question why did you not use * after real madrid sample?

As you use for “the”,”s” etc.

Ответить
Deen Al Islam
Deen Al Islam - 16.01.2023 18:42

अगर 10 बाय 30 सेल में टाइम लिखा है तो उन सभी सेल्स मैं एक साथ 10 मिनट कैसे ऐड करें एक्सएल 16

Ответить
snehal sanap
snehal sanap - 13.01.2023 17:14

Hi sir apka Excel ka class lete hai kya apka location konsa hai

Ответить
eb cy
eb cy - 27.12.2022 22:42

I decided that i bring complete transformation in my life through more studies, practice n will keep on practicing more advance excel n technical knowledge.
It's promise to me.

Great Rajiv Jee, i appreciate ur teaching.
Thanks.

Ответить
Amina
Amina - 20.12.2022 09:43

big thank you, i was really looking for this same formula, finally this video helped me. please share your contact number.

Ответить
R A
R A - 19.12.2022 08:03

Wow Sir ji * is for text and nontext is <> .. thanks

Ответить
R A
R A - 19.12.2022 07:54

Wow Sir ji, Count A se Count ko minus karna maine kabhi socha hi nahi.. dhire dhire acha se samhe aara ha hai . Thanks a lot

Ответить
Subhajit Mondal
Subhajit Mondal - 09.12.2022 20:24

Sir how to count no of cell where time is present!!!! Such as 7:30am, 8:40pm!!!!

Ответить
HEALTH with HOMEO
HEALTH with HOMEO - 01.12.2022 05:51

Amaizing sir, salute you.

Ответить
Pintoo Prasad
Pintoo Prasad - 30.11.2022 20:24

Hello Sir,
How can be update occurance in access similar you have explained in excel like 1, 2, 3

Ответить
jaya sri
jaya sri - 26.11.2022 13:13

Ok if I have the dates from 1st to 30th October but here I want the latest call unique without duplicate with the help of countif formula

Ответить
jaya sri
jaya sri - 26.11.2022 13:09

Hi sir please clear this issue once.. for example if I'm calling my friend multiple times in a month or in a day for this I just want the unique for my latest call if day and time is also not there I want only unique with the help of countif formula without duplicate

Ответить
Cricket Express
Cricket Express - 19.11.2022 18:31

THIS MAN DESERVES MORE SUBSRCIBER

Ответить
Sandeep Verma
Sandeep Verma - 14.11.2022 07:40

À

Ответить
Zannesar Ahamed
Zannesar Ahamed - 03.11.2022 20:24

Very nice sir 👌
My problems solved, thanks sir

Ответить
A kranti Kuta
A kranti Kuta - 24.09.2022 11:03

Sir, I have more than five words in cell I need to find out two words of the cell by countif formula does it possible

Ответить
A kranti Kuta
A kranti Kuta - 21.09.2022 16:36

Muje dashboard ek sheet pe amend ho aur dosre sheet par update ho thanks sir

Ответить
A kranti Kuta
A kranti Kuta - 21.09.2022 16:34

Thanks sir, aap ka Tarika bahut behatar hai

Ответить
Prince Mjprasanth
Prince Mjprasanth - 20.09.2022 13:29

Nice explanation Sir..Thanks for the helpful video 🙏🙏🙏

Ответить
Ram Prasad
Ram Prasad - 13.09.2022 13:02

Great job it helps me alot

Ответить
rahul rakshe
rahul rakshe - 11.09.2022 10:38

nice vedio . but sir please give the saprate excel link for download purpose

Ответить
Vakeel singh
Vakeel singh - 10.09.2022 14:08

sir.... Conditional formating se duplicate value high light hogi.. count to fir karna padega sir..

Ответить
Asif Shaikh
Asif Shaikh - 08.09.2022 14:07

How to use countifs in countifs & sumifs in one Excel sheet to another Excel sheet

Ответить
Murthy Jallu
Murthy Jallu - 26.08.2022 13:32

Dear Sir, we want occurrence based on category

Ответить
Sachin V
Sachin V - 09.08.2022 14:53

how to select the range if the cells are not in sequence

Ответить
Shashi Mukhi
Shashi Mukhi - 04.08.2022 10:52

How to count the cells from a range of where the cells having more than (for example) 6 digits in one cell....pls help

Ответить
Yash creation
Yash creation - 15.07.2022 17:35

every time i need help related to excel i just come here and every time i get solution thank you sir

Ответить
organic  vegetables my mini plantes
organic vegetables my mini plantes - 04.06.2022 17:46

Sir ya btna ki count kro kitna bacha k name ka 2nd letter A h is ka kya formula bnga sir btna please

Ответить
Saket Mishra
Saket Mishra - 22.05.2022 21:31

Sir agar kisi list me koi naam repeated hai aur hame pata karna hai wo naam koun koun se row number me hai to formulae kya lagega

Ответить
TJ R
TJ R - 21.05.2022 12:36

Sir jo last option hai not equal to 1900, "<>" iska matlab sirf 'Not' hota hai na to 'equal to' lagana jaruri nahi hai?.

Ответить