Planilha

[UCHA]

I would like to know, please, how can I make in a spread sheet, the control
separated of products (add or subtraction), despite they being in one same
line, and the launched result being in another spread sheet. Example: I have
in:
"J2" rice; "K2" beans; "L2" rice, etc. The amounts I have in:
"J3"=10; "K3"= 8; "L3"=12, etc.
The results I would like that they were given in one another spread sheet,
and I would be:
"A2"=rice; "A3"=feijão;
"B2"=22; "B3"=8.

Thank you


Gostaria de saber, por favor, se tem como fazer em uma planilha, o controle
(soma) separado de produtos, mesmo eles estando em uma mesma linha, e o
resultado sendo lançado em outra planilha. Ex.: Eu tenho em:
"J2" arroz; "K2" feijão; "L2" arroz, etc. As quantidades eu tenho em:
"J3"= 10; "K3"=8; "L3"=12, etc.
Os resultados eu gostaria que fossem dados em uma outra planilha, e ficariam:
"A2"= arroz; "A3"=feijão
"B2"=22; "B3"=8.

Obrigado

 

[ShaneDevenshire]

Hi UCHA,

Sorry I can't respond in spanish, but here goes in English:

You can either manually create a list of all the unique items in column A of
the first sheet, in the second sheet or you can use Excel's Data, Filter,
Advanced Filter, Unique Records command to do it for you.

On the first sheet select the column A data and choose Date, Filter,
Advanced Filter, choose Copy to another location, make sure the List range is
correct, for the Copy to range click an empty cell, check Unique records only
and click OK.

Copy that to the second sheet. Suppose your list is in column A of the
second sheet starting in cell A2 (data) in B2 enter the formula
=SUMIF(Sheet1!A1:A100,A2,Sheet1!B1:B100).

It is possible to create a formula which will produce the unique value list
but its very complex.