• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I add these 2 cells together

I have formulas in my cells and I want to add the numeric value up. How can I do that using these formulas in the cells =ABS(LEFT(A2,1)-IF(RIGHT(A2,1)="0",10,RIGHT(A2,1)))

If perhaps someone can show me how to add and subtract 1 each I can do the others

As always, thanks in advance. Ya'll are great!!!!
 

Attachments

  • Adding and Subtracting.jpg
    Adding and Subtracting.jpg
    324.9 KB · Views: 11
Jack,

I'm not sure I understand your question. In the topic you want to add 2 cells together, but your posted formula references only 1 cell... Can you post a file rather than a picture ??

Respectfully,
PaulF
 
Using AM6 as an example the formula here will be
=AB6+AC6

Copy AM6 Down

In AN6
= AC6-AB6
Copy down

In AO6
= AE6+AF6
Copy down

in AP6
=AH6+AI6
copy down

I'm sure you get the idea
 
Hi Paul ,

I was using the formula as a reference to let you know te cells had formulas in them. When I tried to do a basic =AB+AC for example I was getting an error so I knew I needed something more


Jack,

I'm not sure I understand your question. In the topic you want to add 2 cells together, but your posted formula references only 1 cell... Can you post a file rather than a picture ??

Respectfully,
PaulF
l
 
Thanks Hui! That's what I thought. I forget the number. Duh. Thanks

Using AM6 as an example the formula here will be
=AB6+AC6

Copy AM6 Down

In AN6
= AC6-AB6
Copy down

In AO6
= AE6+AF6
Copy down

in AP6
=AH6+AI6
copy down

I'm sure you get the idea
ui
 
Is there a way to incorporate an equation like this

5+5=10=1+0=1 the answer is 1
9+7
=16=1+6=7 the answer is 7
6+6=
12=1+2=3 the answer is 3
 
upload_2015-3-1_0-7-7.png


A1=5
B1=5

Array
C1=SUM(MID(A1+B1,ROW(INDIRECT("1:"&LEN(A1+B1))),1)*1)
or
=SUM(--MID(A1+B1,ROW(INDIRECT("1:"&LEN(A1+B1))),1))
 
View attachment 16357


A1=5
B1=5

Array
C1=SUM(MID(A1+B1,ROW(INDIRECT("1:"&LEN(A1+B1))),1)*1)
or
=SUM(--MID(A1+B1,ROW(INDIRECT("1:"&LEN(A1+B1))),1))

What is the purpose of an Array vs a formula? Please educate me. I use them not really knowing why

Do I use this as the formula since it is in AB and AC
=SUM(--MID(AB1+AC1,ROW(INDIRECT("1:"&LEN(AB1+AC1))),1))
 
What is the purpose of an Array vs a formula? Please educate me. I use them not really knowing why

you might intrsred to read h=this for the same.

http://www.cpearson.com/excel/arrayformulas.aspx

https://support.office.com/en-za/ar...formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7

Do I use this as the formula since it is in AB and AC
=SUM(--MID(AB1+AC1,ROW(INDIRECT("1:"&LEN(AB1+AC1))),1))

Why not!!!

You have used SUMPRODUCT(--MID(A1+B1,ROW(INDIRECT("1:"&LEN(A1+B1))),1))

Here sumproduct is by nature a array function so need to CSE/array.
 
it is : Here sumproduct is by nature a array function so no need to CSE/array.
instead of
Here sumproduct is by nature a array function so need to CSE/array.
 
Back
Top