Jawaharp
Have You written: If I select Susp I need to get the count of S in "G" coloum in Base sheet if I select any branch and any one in "segment" and any one "instance" I need to get that count ... and You don't understand Your select.
I have worked for "Instance drop down list" please help to how to work on multiple drop down list with others two
"segment and branch "attachment enclosed for your reference... I have attached as zip file..
well i have used countif function several times in excel but never confronted with the problem which you are describing. so for the reference i can suggest you one informative tutorial link in which several countif function alongwith the fixes are described. you must check it out: COUNTIF Function Issues & Fixes