Hi
Better use pivot table. If you are not clear, send me mail to
with your problem files, i can guide you. I am also from
India.

"Pritesh" wrote:

Hi, this is Pritesh from India. I work for a Pharma & Well Being Group and
prepare monthly MIS reports in Excel. I have to link expense-codes and
relevant amounts to my file from a source file (both .xls files), for which I
use Sumif formula
(=SUMIF('C:\[Source.xls]Jun06'!$F:$F,ExpCode,'C:\[Source.xls]Jun06'!$I:$I).
However, the problem is, unless I keep my source data file open, alongwith
main file, the formula returns with "#Value" error. Can someone help me
discard "#Value" error.