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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|