Hi,

I have Sheet1 in which i have two columns:

A Column is having a Title of Type Of Product
B Column is having a Title of Qty

In A Column i have List Validation (Linked to the Sheet 2) to select
the type of Product. A user has the facility to choose which product
he wants.

The Sheet2 is named as Master.

What I want in Sheet 1 is:

If the user select Single product twice or thrice then the qty should
be added automatically.

I am using following formula which is working fine:

=SUMIF(A4:A10,"=USB",B4:B10)

What I want is instead of mentioning the name of the product in the
formula ["=USB"] can i refer any cell no so that i dont have to change
the formula every time.

Awaiting for a resolution for the same.

Thanks in Advance.

Rgds

Akash Maheshwari