Formula to lookup item for Qty?
 

I currently have a sheet with the following;

A (Items) B C D E

Glasses - -- - 50
Vests --- -- - 10
Hats -- -- - 45
Glasses -- -- - 20
Hats -- -- - 45

Etc, I need a formula if possible to lookup just Glasses in the column and
return total Qty, Hats total qty...etc, etc. Its sort of like an Inventory
sheet but I enter in as purchased nothing comes out in this sheet and at the
end of the month I just want to know how many in total of the specific item
purchased.

Thanks;

Formula to lookup item for Qty?
 

Try this:

=SUMIF(A2:A6,"glasses",E2:E6)

Better to use a cell to hold the criteria:

G2 = Glasses

=SUMIF(A2:A6,G2,E2:E6)

--
Biff
Microsoft Excel MVP


"tb" wrote in message
...
I currently have a sheet with the following;

A (Items) B C D E

Glasses - -- - 50
Vests --- -- - 10
Hats -- -- - 45
Glasses -- -- - 20
Hats -- -- - 45

Etc, I need a formula if possible to lookup just Glasses in the column and
return total Qty, Hats total qty...etc, etc. Its sort of like an Inventory
sheet but I enter in as purchased nothing comes out in this sheet and at
the
end of the month I just want to know how many in total of the specific
item
purchased.

Thanks;

Formula to lookup item for Qty?
 

Here is another way to do it assuming the title in A1 is Items and row 1 has
titles,

In an empty cell enter Items and below it the item you want to find, then
use the formula:

=DSUM(A1:E6,E1,H1:H2)

where H1 has the repeat of the title in A1 and H2 is the item you want to
find.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"tb" wrote:

I currently have a sheet with the following;

A (Items) B C D E

Glasses - -- - 50
Vests --- -- - 10
Hats -- -- - 45
Glasses -- -- - 20
Hats -- -- - 45

Etc, I need a formula if possible to lookup just Glasses in the column and
return total Qty, Hats total qty...etc, etc. Its sort of like an Inventory
sheet but I enter in as purchased nothing comes out in this sheet and at the
end of the month I just want to know how many in total of the specific item
purchased.

Thanks;