Share via

I need the formula to calculate number of items by cost per item = total cost

Anonymous
2017-09-05T04:56:57+00:00

Hi, I am a newbie to Excel and have been unable to find an answer to the above *i.e.*formula to calculate number of items by cost per item = total cost

I am using Win 10 and Office 365

I realise this is basic stuff but as I said, I am a newbie to formulas

Kind regards

Annie

Moved from: Office / Excel / Windows other / Office 365 Home

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2017-09-06T06:22:18+00:00

    Option 1:

    On possibility is you wish to calculate the total cost for each item, where column A mentions No of Items & column B mentions Cost per Item - enter below in cell C2 & copy down:

    =A2*B2

    This will become =A3*B3 when copied to C3, and so on. This calculates total cost for each item separately.

    Option 2:

    In case you want to calculate the total cost of ALL ITEMS, enter below formula in cell E2:

    =SUMPRODUCT(A2:A5*B2:B5)

    This calculates the SUM of Total Cost of ALL Items (this is the same as C7 which is the total of column C.

    Please update the range per your requirement. In case your query is otherwise then please illustrate the same or upload your file for an appropriate solution.

    Regards,

    Amit Tandon

    www.globaliconnect.com

    4 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-05T05:38:44+00:00

    If cell A2 = Number of Items

    Cell B2 = Cost per item

    Then enter below formula in cell C2 which will give total cost:

    =A2*B2

    Regards,

    Amit Tandon

    www.globaliconnect.com

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-09-14T04:43:19+00:00

    I've got it, thank you so much

    0 comments
  3. Anonymous
    2017-09-06T00:30:35+00:00

    If cell A2 = Number of Items

    Cell B2 = Cost per item

    Then enter below formula in cell C2 which will give total cost:

    =A2*B2

    Regards,

    Amit Tandon

    www.globaliconnect.com

    Thank you for your answer. Unfortunately I'm still having trouble. I can make the formula work for one line but not for subsequent lines. I have around 300 items that I need to calculate number by cost. I hope you can help.

    Kind regards

    Annie

    0 comments