Countifs Formula in Excel | Countifs Function with multiple criteria | Counifs Function in Hindi

[@dasarinaresh8695]

Excellent Video , easy to understand , thanks

[@AlamHindiGuide]

Thanks

[@LaxmiVlogs706]

Good example keep going 👍

[@AlamHindiGuide]

Thanks

[@nirmalrana9439]

Excellent

[@AlamHindiGuide]

Thanks

[@andreas_Salve]

Thanks

[@HighMotiveandpodcast]

Good work bro

[@AlamHindiGuide]

Thanks

[@mdbaharalam0665]

Good

[@AlamHindiGuide]

Thanks

[@abhinandankumar8341]

Nice

[@AlamHindiGuide]

Thanks

[@iqrazonecommerce6126]

Sir please help.
Example.
If there is 5 in column A then write XYZ and if there is 18 in column A then write ABC and if there is 12 in column A then write pqr If there is 28 in column A then write MNO
Which formula will be used for this? ?

[@AlamHindiGuide]

Option 1.
=ifs(A1=5,"XYZ",A1=12,"PQR",A1=18,"ABC",A1=28,"MNO","NOT AVAILABLE","TRUE")
Option 2.
=If(A1=5,"XYZ",IF(A1=12,"PQR",IF(A1=18,"ABC",IF(A1=28,"MNO","NOT AVAILABLE")))
There are two options if you have ms excel 2007 then use option 2 otherwise use option 1.
If your problem is resolved then share this channel with your friends. Thanks 👍

[@iqrazonecommerce6126]

Thank you sir ji

[@johnsonchelladurai6829]

In my activity I have 3 status one is completed second is in progress and 3rd one is not started. I want count except completed how activity is there. How to use countifs formula

[@AlamHindiGuide]

=countif(range, criteria)+countif(range, criteria)
Apply countif formula like this, if your data has in single column.
If you didn't understand than send a screenshot of your data (demo).
Thanks for comment ☺️

[@tradetrials]

Mera data aisa hai:
No Left Right
8 yes yes
9 yes no
3 no no
7 no yes
6 no no
Mujhe count karna hai ki aise kitne rows hain jismein number >=5 hain aur Right ya left mein se ek ya dono "YES" hain. Ye kaise karenge.

[@akshaythakur6484]

how do i use countifs function in filtered data?

[@AlamHindiGuide]

I'll make a complete video on this soon so subscribe this channel for further updates

[@akshaythakur6484]

please make video on how to use countif function for greater than, less than type and countifs function for filtered data.@@AlamHindiGuide

[@AlamHindiGuide]

Hi Akshay
Check my latest video "countifs function on Filtered Data" and let me know if your problem is resolved 👍

[@afrinjaman3232]

Mera nhi horha h😢

[@AlamHindiGuide]

Try again with step by step 👍

[@afrinjaman3232]

Try kiye Hai bht br but answer 0 hi arha Hai..

[@AlamHindiGuide]

@@afrinjaman3232 instagram.com/alamhindiguide?igshid=OGQ5ZDc2ODk2ZA==
DM me on Instagram

[@sayensamallick6626]

Ho jata hai basically agar nhi hua toh countif+countif Karo ho jayega​@@afrinjaman3232

[@AbhishekMishra-iv2np]

😂