Hi,
Not sure if I understood you, you want to filter let' say product X and
obtain the sum in column N only for that product , in column N row 2001 enter
this formula

=subtotal(9,N1:N200)

it will change the total to the filtered rows

"Jessejames" wrote:

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