Bob Phillips Wrote:
Have you tried my formula?



Yes, Bob.

The answer is always 0 when I put your formulas in C2 and D2, and drag
down to fill up the whole sheet. I guess because there are data in
A3,4,5... and B3,4,5..., and the number of items in each cell is not
even.

I also tried to put the formulas at the bottom of the records to allow
more room for the indirect commend, this time some answers are correct,
but most of the answers are still 0. I have 120 records in this sheet
and I really hate to do it manually.

Thanks a lot!


--
sun1x
------------------------------------------------------------------------
sun1x's Profile: http://www.excelforum.com/member.php...o&userid=28327
View this thread: http://www.excelforum.com/showthread...hreadid=479096