+ Reply to Thread
Results 1 to 5 of 5

Tshirt orders spreadsheet, Trying to have sizes auto add up to dollar amounts

  1. #1
    Registered User
    Join Date
    02-15-2020
    Location
    San Antonio TX
    MS-Off Ver
    excel
    Posts
    2

    Tshirt orders spreadsheet, Trying to have sizes auto add up to dollar amounts

    I am making a spreadsheet of T-shirt orders. I am attempting to make each size equal a dollar amount. I want to be able to put the sizes in one cell and the dollar amount add up in the next cell over. For example if a person ordered 3 shirts (YS, AS,AL) I want to be able to put the sizes ordered in one cell. Then each shirt is $25.00 so I want the amount to calculate in the next cell over. Is there a way for me to make each abbreviation equal a dollar amount and it automatically create the sum in the next cell over. Please help me as I am a beginner in Excel.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    10,684

    Re: Tshirt orders spreadsheet, Trying to have sizes auto add up to dollar amounts

    That's a bad idea. How will you count the total number of each size needed to cover ALL ORDERS.
    However, you can put in column H:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-15-2020
    Location
    San Antonio TX
    MS-Off Ver
    excel
    Posts
    2

    Re: Tshirt orders spreadsheet, Trying to have sizes auto add up to dollar amounts

    So there’s no way to see how many of each size there are?

  4. #4
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    9,660

    Re: Tshirt orders spreadsheet, Trying to have sizes auto add up to dollar amounts

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    10,684

    Re: Tshirt orders spreadsheet, Trying to have sizes auto add up to dollar amounts

    A separate column for each size; then just SUM formulas.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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