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

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


.

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

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


.

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.

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


.