Querry in relates to the function SUMIF

[Akash]

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

 

[GS]

Akash explained :

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

If your Master sheet has a list of all Product Types in columnA
starting with $A$1, then enter the following in $B$1 and copy down:

=SUMIF('Sheet1'!$A$4:$A$10,$A1,'Sheet1'!$B$4:$B$10)