Sum of retuned valus as digits

[Vinay Vasu]

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

 

[R Gunnet]

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"

 

[Bernard Liengme]

You give us little to work on.
How about =SUM(A1:A10) ?
best wishes

 

[JLatham]

sorry, I don't have an answer for you, but perhaps someone at Microsoft
Answers will
http://social.answers.microsoft.com/Forums/en-US/officeinstall/threads?filter=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.

 

[Intel]

I cant get your question but i ll explain it little
if you have used this function in a cell
i.e
=if(CELL4>43,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 row
or columns then
Also Note that i have used this function =if(CELL4>43,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.

 

[Brad]

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