#1   Report Post  
Colin2u
 
Posts: n/a
Default 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   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Colin2u
 
Posts: n/a
Default

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   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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   Report Post  
Colin2u
 
Posts: n/a
Default

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   Report Post  
MrShorty
 
Posts: n/a
Default


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
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
Payroll calculator template Eagle View Construction Excel Discussion (Misc queries) 0 May 3rd 05 01:49 AM
Loan Calculator for more than 30 years Ray_Johnson Excel Discussion (Misc queries) 1 March 30th 05 08:01 PM
loan calculator cells, P&I formulas do not copy to second cloumn Mr. C Excel Worksheet Functions 4 March 5th 05 03:45 PM
payroll calculator for ontario canada, cant convert ontario rates. sue Excel Discussion (Misc queries) 0 January 29th 05 09:33 PM
Auto Loan Calculator Robert Excel Worksheet Functions 5 January 10th 05 07:20 PM


All times are GMT +1. The time now is 02:14 AM.

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

About Us

"It's about Microsoft Excel"