Results 1 to 2 of 2

Thread: Help for fledgling ebay start-up hugely appreciated

  1. #1

    Help for fledgling ebay start-up hugely appreciated



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I apologise if these questions are offensively nooby, I know nothing of excel but here goes. I need to assign a cell to sum the values that I might highlight in my price column; so I may be highlighting H3,H7,H14,H23,H31 for example. In a cell below this I need to subtract from the above sum, the number of highlighted cells x listing fee (which for me is 0.26) So for the given example it would be 5x0.26. So in a cell at the top of the sheet it may have added the figures found in the H cells, say, 5,10,5,4,7 to show 31, and then a cell below shows 29.7 [31-(5x0.26)] I also have to take off percentages for other fees but I think I can work that out once I know these answers. Once again, help hugely appreciated. NB. I'd like to make this post neater but my mfing return key just will not work.

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,233
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Yorke, welcome to the forum.

    First off, I assume you're using Internet Explorer 10 to write. It has a habit of screwing with the mfing return key. If you set this forum to show in Compatibility mode for IE8 or IE9 it will work nicely. (I only know this because it's happening to me too. I need to apply an upgrade to the forum to fix it.)

    With regards to your question, are you attempting to add up the cells that you've coloured then? It might be helpful to see a sample workbook (if you click Go Advanced you can upload one for us to look at) that shows what you are hoping to have happen.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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