Closed Thread
Results 1 to 2 of 2

Formula for Selling Price - Cost, only if Sold

  1. #1
    Registered User
    Join Date
    11-07-2018
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Formula for Selling Price - Cost, only if Sold

    Hi,

    I've been trying to do this for the past hour with no luck so hopefully someone on here can help me

    What I want to do is in Minus the cost of a product (Column D) from the selling price of the same product (Column C) only if SOLD is written in Column E, and then have the total of this in Column F.

    I've tried SUMIF which seems to be the right formula but no matter what I do it doesn't seem to work.

    If anyone could advise me on what to do I would be very grateful. Any other information you need please let me know

    Thanks,

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,859

    Re: Formula for Selling Price - Cost, only if Sold

    Duplicate closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Forumla for Selling Price - Cost, only if Sold
    By Kevin.Es in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-08-2018, 08:22 AM
  2. Calculate selling price with the cost and margin%
    By carnagelan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2018, 04:00 PM
  3. Count selling price by sliding cost percentage
    By oeyandyprawira in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2016, 07:14 PM
  4. Dealer discount, margin, cost of goods but what will the selling price be?
    By Calculation1956 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2016, 01:36 PM
  5. [SOLVED] Setting a selling price based on cost price and order quantity
    By Steven811 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2014, 08:07 AM
  6. Cost to Selling Price Viability Calculator
    By Margaret jackie in forum Excel General
    Replies: 5
    Last Post: 11-15-2012, 05:42 PM
  7. Costs Price Profit and Cost of goods sold
    By kraysellz in forum Excel General
    Replies: 1
    Last Post: 10-24-2010, 12:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1