A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sum of retuned valus as digits



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 09:43 AM posted to microsoft.public.excel.newusers
Vinay Vasu
external usenet poster
 
Posts: 6
Default Sum of retuned valus as digits

Hello there,

I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.

Thank you

Jeevan


  #2  
Old April 16th, 2010, 03:49 PM posted to microsoft.public.excel.newusers
R Gunnet
external usenet poster
 
Posts: 1
Default Sum of retuned valus as digits

I have a new question and cannot get the website to let me start a new
thread, but I need help with the function described below regarding the
midsection of the bottom taskbar. This functionality suddenly stopped
working on my excel and I cannot figure out why. It works fine on Word, etc.
Can anyone help?

this came from a micrsoft website.......
"That's where the taskbar comes in handy. Whenever you open a program,
folder, or document, Windows creates a button on the taskbar corresponding to
that item. The button shows the icon and name of the item. In the picture
below, two programs are open—Calculator and Minesweeper—and each has its own
button on the taskbar.



Each program has its own button on the taskbar"
--
Regina L Gunnet, CPA, MHA


"Vinay Vasu" wrote:

Hello there,

I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.

Thank you

Jeevan


.

  #3  
Old April 16th, 2010, 06:48 PM posted to microsoft.public.excel.newusers
Bernard Liengme
external usenet poster
 
Posts: 516
Default Sum of retuned valus as digits

You give us little to work on.
How about =SUM(A1:A10) ?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Vinay Vasu" wrote in message
...
Hello there,

I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.

Thank you

Jeevan

  #4  
Old April 17th, 2010, 12:54 AM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default Sum of retuned valus as digits

sorry, I don't have an answer for you, but perhaps someone at Microsoft
Answers will:
http://social.answers.microsoft.com/...ilter=alltypes
I would think that this falls into the "setup" category and would be a valid
question there since you cannot get a new question started here.

"R Gunnet" wrote:

I have a new question and cannot get the website to let me start a new
thread, but I need help with the function described below regarding the
midsection of the bottom taskbar. This functionality suddenly stopped
working on my excel and I cannot figure out why. It works fine on Word, etc.
Can anyone help?

this came from a micrsoft website.......
"That's where the taskbar comes in handy. Whenever you open a program,
folder, or document, Windows creates a button on the taskbar corresponding to
that item. The button shows the icon and name of the item. In the picture
below, two programs are open—Calculator and Minesweeper—and each has its own
button on the taskbar.



Each program has its own button on the taskbar"
--
Regina L Gunnet, CPA, MHA


"Vinay Vasu" wrote:

Hello there,

I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.

Thank you

Jeevan


.

  #5  
Old April 17th, 2010, 12:16 PM posted to microsoft.public.excel.newusers
Intel
external usenet poster
 
Posts: 1
Default Sum of retuned valus as digits


I cant get your question but i ll explain it little
if you have used this function in a cell
i.e
=if(CELL443,6,0)
which is equal to the 6 if CELL4 is greater than 43
Now you want to add this 6 of if function into to other cells of rows
or columns then
Also Note that i have used this function =if(CELL443,6,0) in CELL5
simply do the following

=SUM(CELL5:36)
or
=SUM(CELL5:CELL2)

etc

If you not got that then explain your Question.
Vinay Vasu;946307 Wrote:
Hello there,

I am using IF function to return values as digits. Now I need the sum
of
such digits in a coloumn. Pease help me to do this.

Thank you

Jeevan





--
Intel
  #6  
Old April 22nd, 2010, 09:19 PM posted to microsoft.public.excel.newusers
Brad
external usenet poster
 
Posts: 943
Default Sum of retuned valus as digits

Are you wanting 123 in one cell to be considered as 6?
If so,

=SUMPRODUCT(--MID(A2,ROW($A$1:INDEX($A:$A,LEN(A2),1)),1))
where the 123 is in cell A2

--
Wag more, bark less


"Vinay Vasu" wrote:

Hello there,

I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.

Thank you

Jeevan


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:44 AM.


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