vlookup

[jg]

I would like to do the following calculation which I think should be done
with the vlookup function, but it may be another function.

I have a table containing 3 columns. Column A list the category (Clothing,
food etc.). Column B lists the item within the category (from Column A).
Column C lists the price of the item in column B. I would like to list on a
new table (on a different worksheet) all the categories (from the 1st table
in column A) on column A of the new table. I would like to have a formula in
column B of the new table totaling the price of all the items (from the 1st
table, column B) belonging to the category listed on column A of this row (in
the new table).
--

jg

[Peo Sjoblom]

Sounds as though you could use

=SUMIF(Sheet1!$A$2:$A$500,A2,Sheet1!$C$2:$C$500)

or

=SUMPRODUCT(--(Sheet1!$A$2:$A$500=A2),Sheet1!$C$2:$C$500)

where A2 is the first category, copy down the formula

You could also use a pivot table


Regards,

Peo Sjoblom

"jg" wrote:

> I would like to do the following calculation which I think should be done
> with the vlookup function, but it may be another function.
>
> I have a table containing 3 columns. Column A list the category (Clothing,
> food etc.). Column B lists the item within the category (from Column A).
> Column C lists the price of the item in column B. I would like to list on a
> new table (on a different worksheet) all the categories (from the 1st table
> in column A) on column A of the new table. I would like to have a formula in
> column B of the new table totaling the price of all the items (from the 1st
> table, column B) belonging to the category listed on column A of this row (in
> the new table).
> --
>
> jg