Who knows Excel?

[blizzardplowman]

Ok, I have this huge spread sheet from a vendor, I want to edit it to include my quanity on hand and my total cost per. I need to total row F which is a $ amount to row G which is quanity. Then I need to total row G for the cost of material I have on hand form this vendor. I normaly can make this work, but for some reason i am brain dead today.

THEIRS ...... I ADDED THESE

D ... E ... F ... G ... H
PART ... MSRP ... COST ... QOH ... TOTAL

B60095.. $20.00 .. $12.00 ... 4 ... ?
B60097.. $20.00 .. $12.00 ... 1 ...
B60099.. $300.00.. $180.00 ... 5
B60189.. $156.00.. $93.60 ... 2
B60163.. $350.00.. $210.00 ... 4

TIA
Marty

 

[buddy]

To do this, columns are letters, rows are numbers
In the H column (total) select the first cell you want to show a total and write =F#*G# where # is the corresponding row #. Then just select the bottom right corner of that cell and drag is at far down as you want and it will calculate it for every corresponding row, automatically replacing the # with the sequential value.

To then add them all up. go to any cell and type in =sum(G#,G#), from whatever cell you want to start to the ending row, or once you get to the point of typing SUM( it will give you option to just drag and selcect all the rows that way. That will give you total # parts on hand.

Do the same for total cost, pick any cell and tpye in =sum(H#,H#)

You can do any type of math equation you want using / to divide and * to multiply, but you always have to start with the = if you want it to be an equation.

 

[Clark20ry]

You can send the sheet to me and I can do it for you...

 

[saratoga]

In H2 type this: "=Sum(F2*G2)"

Right click and copy H2

Highlight the H column all the way down to where you have values, choose "Paste Special, Formulas"

At the end, to calc your total cost:
In H(#) type: "=sum(H2:h?)" with the question mark being the last H cell with a value you want to add.

Right click the H cell with the total, choose Format Cells, under the Number Tab, choose Currency from the list.

 

[blizzardplowman]

Thanks Guys. I'll work on it Friday.

Thanks GUYS! all done, made my day a whole lot more simple. I hate inventory ):h