Without more details to go on, I think the SumIf function is what you're
looking for.
HTH,
--
Gary Brown



"djm" wrote:

i want to know how can i link two excel fiels to each other. e.g. i have one
detail sheet and total of that file i want to appear as summary in one of the
cells of other file and not other sheet. please let me know.