I'm an excel noob!

[mason]

okay.. I need to add the totals of some cells, but I don't quite know how to form the equation to do it.

I want to add up every other 6th cell starting with B5. So I basically want to do "=B5+B11+B17+etc etc etc". I don't want to manually enter every cell to add so is there an easier way?

I have all the cells I want to add up labled with the same name so maybe there's a way to add all the cells with the same names together?

 

[Palmerville]

1) Sort
2) Subtotal

 

[Jdog]

or you can do

=sum(b1:b1009)

Just replace b1 for your starting cell and b1009 to whatever your ending cell is.

There is also an autoformula button. It looks like a greek letter, and resembles a capital "E", click on that and you will see sum, avagerage etc... click one of those and just highlight the cells and hit enter.

 

[dastuff]

Haha this was kind of fun to figure out but I solved it....

Next to B5 (hopefully A5 is still blank if not just insert a new col (i hope you know how to do this)

place a 1... then in the row directly below it place the below code and drag it through all the values you want (all 10k of them or whatever).

=IF(A5<6,A5+1,1)   1

Basically all this part is doing is creating a counting system (that cycles through 1-6)... Note that if you had to insert a new col you'll have to shift the cells over accordingly.

Then on a col. to the right (we'll for the sake of this argument assume this is happening in the c col) use this.

=IF(A5=1,B5,0)

This is checking your reacurring # col and placing the value of B5 if it's one that you need and placing a zero if it's what you don't need. (it will look like 6.5,0,0,0,0,0,8.32,0,0....) And drag this through the whole problem....

Now all you need to do is sum this newly made col

=SUM(C5:C1000)

And you've got it...

I looked around for a function to do this but couldn't find one easily, and it's funner to program it anyways.

Hope that helped :rasta:

 

[LinkJunkie]

Good excel info dastuff.