How to add 2 columns value in 1 column

M

Muheet Khan

Hi,

I want to add 2 columns value (verticaly) in 1 column
example

2 4
2
2 4
2
2 4
2

Thanks
 
J

JohnI in Brisbane

Muheet,

If your data starts in A2 then put the folloing formula in B2,

=IF(MOD(ROW(),2)=0,$A2+$A3,"")

& drag down as far as you need.


It gives the total of two rows, in every second row.

regards,

JohnI
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
List all tables, including document structure 0
Finding the right style field in VBA 0
Remove Identical words 0
Sum Values from different column 1
Need help merging Excel into Publisher Booklet w 2 columns 0
Split cells next to 1 cell 1
Grow/Shrink Text gradually from slide to slide 0

Top