Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Planilha

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Planilha Diogo Alves New Users to Excel 2 January 7th 07 07:09 AM
Execução de macros ao abrir planilha Luiz Silvestre de Azevedo Excel Worksheet Functions 2 June 20th 06 04:24 PM
Planilha de Impostos Federais e Estaduais Jemelly Rustom Excel Discussion (Misc queries) 0 January 28th 06 02:06 PM
Divisão da planilha. Felipe Excel Discussion (Misc queries) 0 June 23rd 05 05:11 PM
PLANILHA EXCEL Othon Moraes Excel Discussion (Misc queries) 0 May 2nd 05 09:59 PM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"