How to Count Unique Values with Multiple Condition in Excel | Countifs with Multiple Criteria

Hi, @TeachtoEach
mughay date wise unique valuse jo dosray columun may hon karna woh kasay hoga

IS RANGE ME BLANK ROW V SELECT REHNE PAR RESULT ZERO AA RAHA HAI, PLEASE SUGGEST

Dil se thanks brooo...❤️

Thanks to you
I am from bangladesh.
Happy New Year
Thanks Again

Bohot biriYa hay bro.

Sir,

Countifs ke sath subtotal kese use kare ge

One of the best formula I have seen. Awesome sir please do make such videos more in future.

Awesome dear. Lots of love and respect. I was looking exactly for this formula for my office work. Thanks

good

Total sum of duplicate repeated item value in excel 2020 in hindi

Super .. thank you.

Thanks for the vedio, I tried, but formula is not working.

Thanks sir very helpful video

Thank U Sir. This video helped me a lot.

Hy

sir link kaam nahi kar raha please help me sir

What if we have blank cell between the range?

This formula is not work in 2 ,3 lacs rows data

You can simply do this by using single formula =sumifs rather than to combine three different formulas

Sir, you making much easier and suitable excel for us. and teaching in energetic way. it's really awesome many things which i don't know i know very well after than seeing your videos.

Thanks 🙏

Sir your viewing of videos are always energetic its really y awesome.

Excellent Wok, G R E A T

Nice interview question.

Thank you Ashish...I am struggling to find out solution in similar scenario...I use subtotal very often...now imagine we have subtotal already applied on first row...right on top of titles (headers) now when we select any particular month.. subtotal of that month will automatically update...but unique count of product for that month doesn't update using sumproduct alone....I want total of sales and count of unique product reflecting on top whenever any particular month is selected (through filter)....hope I was able to convey my query....it would be great if you could help me here..thank you..

Very helpful

hi sir i have some problems in SUMPRODUCT on date automatically by filters plz guide

Thank you so much.

nice 👍🏻👍🏻👍🏻👍🏻

This is a life saver thanks..❤️

Sir, sumproduct में तो ctrl shift enter press nahi करते तो इसमें क्या वजह थी जो ctrl shift enter use हुआ है1

Sir, Colam me Marj kar unice veliu nikale yesa video banayen

Why AND with IF not working?? I have 2 conditions

Hi bro, I have a query, you have given one condition but I have some data where I have to give 2 condition...means search April in B column and search Tea Leave in C column then count unique of total sales..plz help to give this formula..
I have tried if & and together but it didn't work....
Can u plz help...

Sir, esi sheet me, suppose tea leave ka tino sale alag alag amount ho jaise-1000,2000,2000, aur mujhe check karna ho ki april month me tea leaves ka 1000 se jyada unique count value kitna hai.
please reply.

Thx for this videos

Kam nhi Kar Raha he mujhe number format me unique count Karna he multiple condition ke sath.

Thank you. I have a blank cell in between the criteria, result shows NA. Can u help me out pls

Month Location Dealer Product Qty
Apr ED A FL 1
Apr ED B FL -1
Apr ED C TL 2
Apr ED D MW 1
Apr ED A FL 2
Apr ED A FL 3
Apr WD A AC -2
Apr WD A AC 1
Apr WD B FL 1
Apr WD B TL -1
Apr WD C MW -10
Apr WD D DW -20
Apr WD C MW 2


Month Apr
Location ED
Product FL

Count of Unique Dealer

Can u pl help me on this i want Apr month ED location Product FL unique dealers (-0 should not be count.. (Negative value should not be count)

Please

Hi I have an doubt regarding this formula can u Pl call me on 7210121000

Great sir, please create kpi matrices topics

BHAI BIG DATA ME CONCATANET FORMULA USER KAR KE MIX TEXT & NO. SPECIAL CARATERS ULAG KARANA SIKHAO

Awesome

It's awesome. Thanks Ashish sir for making videos like this. I salute you and your knowledge.👌

It's hard

Omg sir