Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculator
is there a formula or a calculator that can be placed in a cell to SUM up the
value or difference amount and gives a total in a specific requested cell. i am bringing different # amount to be totaled and placed in requested cells of choise. |
#2
|
|||
|
|||
Please try rephrasing question (maybe with example)
You have a range of cells with numbers. What do you want to SUM? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Colin2u" wrote in message ... is there a formula or a calculator that can be placed in a cell to SUM up the value or difference amount and gives a total in a specific requested cell. i am bringing different # amount to be totaled and placed in requested cells of choise. |
#3
|
|||
|
|||
I would like to have a calculator that will calculator 2-3 or more
calculations of different amount and have the result or total be placed in a specified or requested cell. "Bernard Liengme" wrote: Please try rephrasing question (maybe with example) You have a range of cells with numbers. What do you want to SUM? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Colin2u" wrote in message ... is there a formula or a calculator that can be placed in a cell to SUM up the value or difference amount and gives a total in a specific requested cell. i am bringing different # amount to be totaled and placed in requested cells of choise. |
#4
|
|||
|
|||
An example might help interpret what you are trying to say.
Have you looked at Help for the SUM function? Jerry Colin2u wrote: I would like to have a calculator that will calculator 2-3 or more calculations of different amount and have the result or total be placed in a specified or requested cell. "Bernard Liengme" wrote: Please try rephrasing question (maybe with example) You have a range of cells with numbers. What do you want to SUM? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Colin2u" wrote in message ... is there a formula or a calculator that can be placed in a cell to SUM up the value or difference amount and gives a total in a specific requested cell. i am bringing different # amount to be totaled and placed in requested cells of choise. |
#5
|
|||
|
|||
at the end of the week I gather my and input the expences for different
catigories. some catigories has different sub-catigories and each has their own input of $ amount. Eg: My Family Budget Plan with diffeerent catigories and Sub-catigories. catigorie "House" sub-catigorie: utilitiy / Tel. / rent / Groceries ... thus the same for other main catigories each sub-catigories has different $ amount input so its hard to keep manually totaling (different Grocery totals) and then entering that total aas one entry for the sub-catigory "Groceries". "Jerry W. Lewis" wrote: An example might help interpret what you are trying to say. Have you looked at Help for the SUM function? Jerry Colin2u wrote: I would like to have a calculator that will calculator 2-3 or more calculations of different amount and have the result or total be placed in a specified or requested cell. "Bernard Liengme" wrote: Please try rephrasing question (maybe with example) You have a range of cells with numbers. What do you want to SUM? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Colin2u" wrote in message ... is there a formula or a calculator that can be placed in a cell to SUM up the value or difference amount and gives a total in a specific requested cell. i am bringing different # amount to be totaled and placed in requested cells of choise. |
#6
|
|||
|
|||
My standard approach to such a problem is to place the raw "grocery" data in another part of the worksheet (or maybe another worksheet in the same workbook). Then the "grocery" cell can become =sum(aa1:aa10) where aa1:aa10 is the range where you put the raw grocery data. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=396812 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Payroll calculator template | Excel Discussion (Misc queries) | |||
Loan Calculator for more than 30 years | Excel Discussion (Misc queries) | |||
loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions | |||
payroll calculator for ontario canada, cant convert ontario rates. | Excel Discussion (Misc queries) | |||
Auto Loan Calculator | Excel Worksheet Functions |