Of course the example I gave showed the return area on the same page as the
data, but there is no reason you can't do the same think on a different page.
The formula would just contain the sheet reference. It would look something
like:
{=SUM(IF((SheetData!B2:B6="A")*(SheetData!A2:A6="J AN"),SheetData!C2:C6))}


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1