Have a look at SUMPRODUCT. Good explanation at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"aromaveda" wrote
in message ...

I can get the net inventory on hand by using SumIf function but I cannot
figure out how would I do the datewise aging. If you could give me some
ideas I will try on my own and will seek your adivse when stuck

Thanks
Sanjay


--
aromaveda
------------------------------------------------------------------------
aromaveda's Profile:
http://www.excelforum.com/member.php...o&userid=29449
View this thread: http://www.excelforum.com/showthread...hreadid=494868