i have 2000 rows and 2000 columns
in one column, after searching for this product x. this value of all the
product x will be summed up on below , for every search, there will be
automatic sum for every product.(is it possible?)
this is sample data

(these are filtered items)
col b col n
row 5 product x 1000
6 product x 1500

row 2001 product x ( ??? )

at row 2001 (this will be the formula bar that will calculate the col n of
the said product.
if i search product y, the same formula which product x defined. it will
input the product y and the total ( ??? )
and so on....

IS IT CLEAR?










--
xxxJessexxx