Hi,

I have somedata in one excel file (say Data1.xls) and want the summary
(Count) of that data into another excel file (say Result1.xls).

There should be 2 conditions to it. The first one is I have got a date in
Result1.xls (say 1-Jan-08) this date should be checked in Data1.xls and if it
matches then the second condition is Name in Result1.xls (say John). If date
and name is 1-Jan-08 and John respectively then I should get the Count of
name (John) on 1-Jan-08 in Result1.xls.

I tried with Countif function, but I am getting any one of the above
condition and not both.

Hope I am able to convey what I require.

Cheers,
Mandeep Dhami