Excel Code......

[InLoveWithDOTS]

I am trying to create an excel chart that will add, mutltiply, etc. Can you tell me the code to model my info after? Is it something like B3toB9= B11 if I want to add the column B and have it total? LOL, does that even make sense?

[YvetteSanders]

Nope - should be sum(b3:b9) - this should be in the cell you want the total in - using your example in B11

[Hom74]

Remember you have to put the "=" before the equation ==> =Sum(B3:B9). I usually type =Sum and then use my mouse to highlight the series of numbers.

[InLoveWithDOTS]

You girls rock my socks! I can get answers to anything SO fast here! What about divided by or multiplication?

[Hom74]

just use the symbols on your keyboard:

=C22/C23
=C22*C23
=SUM(B9:B20)*1.0825 (lol if you want to add up a bunch of items and see the total it would be w/8.25% sales tax lol)

[Hom74]

Another Excel tip, in a cell you can type "=" and look up at your tool bar where it normally shows the cell number (A3 or E22 or whatever)...after you type the "=" it will say "SUM" (at least most likely it will say that lol). You can click the down arrow and find the type of equation you want to do. A little box will pop up that will help (or maybe confuse even more lol) to create the equation if you type in the cells numbers or click on the cell.

Hope that made sense.

[hawaiianbrat96]

Karen, you rawk! I was going to post the same info!!

[InLoveWithDOTS]

You girls are seriously the best! Thanks for this quick refresher course! :)