In a execl worksheet with 100 row & column, how to add sum of row 1, 3, 5.....99 in one cell & 2,4..100 in one

Question

In a work sheet(excel) of 100 row & x column , how to add sum of odd cell(1,3,5.....100) one cell & sum of even cell(1,2,4....100) in another cell or how to add sum alternate in one cell

Answer 1

I would type the formula "@sum( "and then while holding the shift botton down, select the cells you want added in. when done, hit enter.

I'm sure that there is a fancy formula, but it would take me 4 or 5 years to figure it out.

Answer 2

I believe you want to ad the rows with the least amount of manual work. The best solution is to add an extra column that will depict whether a row is even or odd, then use the SUMIF function. I will assume that your data is in column A and I will put the answers in cells A101 and A102 for the odd and even cells respectively.

The extra column will be column B. In cell B1,copy the following formula: =MOD(ROWS(B1)). Copy this formula to the other 99 cells in column B. You will see a 0 for even rows and a 1 for odd rows.

In cell A101, copy this formula: =SUMIF(B1:B100, 1, A1:A100)
In cell A102, copy this formula: =SUMIF(B1:B100, 0, A1:A100)

If you look at Excel Help for the SUMIF function, it explains how the parameters are used: the first parameter is the range that has the conditions to determine if a row will be added or not; the 2nd parameter says to add if there is a 0 - or a 1 - in the row; and the 3rd parameter tells you where the data to be added comes from.

Answer 3

What I would do is insert a new column. In that column enter 1 thru 50 in the even rows and a through zz in the odd rows. Then sort the sheet my that new column. Sum the numerics , then sum the alphas. Be sure to copy, paste special value because when you resort the sheet, the calculation will get honked. Good luck.
-MM

Answer 4

VIP seats for the Topeka Kansas show coming up next spring would probably be best. Spring in Kansas is a great time... the weather is nice, and there are all kinds of bizarre cars that look like tanks driving randomly across fields. It's like the Road Warrior, but in the Dust Bowl, not Oz.

Answer 5

Ok, so I am going to assume that your numbers are in column A.

Use this formula in column B:

=IF(MOD(CELL("row",A1),2), 0, A1)

Use this formula in column C:

=IF(MOD(CELL("row",A1),2), A1, 0)

Put that formula into all of the cells in the columns. (Put the formula into row 1, then drag down to row 100 so that the formula changes for each row, using cell A1, A2, A3 as they go down the column...)

In cell D1, you can place this formula to get the sum of all odd rows:

=SUM(B1:B100)

In cell E1, you can place this formula to get the sum of all even rows:

=SUM(C1:C100)

Answer 6

I'd love to help, but I don't understand the question. Are you trying to calculate the sum of all the even values and calculate the sum of all the odd values?

Answer 7

In the desired cell, put the formula: =SUM(A1,A3,A5,A7,A9,A11...A99) for the odd numbered cells.
=SUM(A2,A4,A6,A8,A10...A100) for the even numbered cells.