Find solution
How do I add an item to Finder's sidebar?

How to add the cost based on item in excel?

  • If you have spent a certain amount of money on every item and would like to add it how would you come up with a formula given the following arrangment; Item Amount Spent 3001 $583 3001 $32 3004 $9 3001 $15 3004 $58 3010 $17 3001 $76 3004 $35 I want to know how much I spent on each item. How can i add up the cost? Thank you for your help!!

  • Answer:

    I see different amounts for item 3001 and 3004. To get an each cost there would have to be a quantity. Set column A, row 1 to 'ITEM, B,1 to 'Quantity, C,1 to 'COST EA and D,1 to 'LINE TOTAL. In cell D2 enter the formula =sum(B2*C2) copy this formula down the column by holding down the left mouse button on the black box in the lower left corner of the cell. Fill out the rest of your purchase infomation and you will have sub totals for all the items. To get item totals you will need to filter your data, here's a link describing how. http://www.microsoft.com/canada/smallbiz/products/howto/use-excel-filtering-to-find-data-fast.mspx

Vote independent at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

You can use a formula like this. This assumes the data to be in column A and the amount spent in Column B. =SUMIF(A:A,A1,B:B) The A1 that is in the middle of the formula could reference another cell say F1 that you could enter the item number in. You could also have a list of the items and you could enter this formula next to the list and all you would have to do is to change the A1 in the middle of the formula to match the top of the list of items and copy the formula down the length of the list of items. Eg. If your list of items started in F1 and went down the column, enter the formula in G1 and change the formula to be =SUMIF(A:A,G1,B:B) Then copy down the length of your item list. The total amount spent on each item will be presented to you.

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.