get a count of filtered data , count should be as values in cell.

i have attached data, it has 6 columns SlNo. Name In experience Task Date
i need to filter this data at 3rd column filed In as "yes", Experience field as "No", Task field as "completed" or say nonblank,
so i need to get a count of filtered data, that is how many Names falling in such criteria. That count should get reflected in a cell.
i could do this using pivot table, so by refreshing everytime... i could get a count updated everytime when data changes.
But i there a way, to get a count everytime when data added to this file... a formula or code would help me to suit 2003excel?.
without using pivots.