+ 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
    12,570

    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 Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    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

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

    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)

Similar Threads

  1. [SOLVED] need to break down dollar amounts to 100's, 20's, 10's and 5's.....HELP?
    By JTHernandezJ in forum Excel General
    Replies: 7
    Last Post: 04-10-2017, 02:37 PM
  2. Turning even Dollar Amounts to odd Dollar Amounts
    By Tim D in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2015, 04:32 PM
  3. dollar amounts
    By atcspaul in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2012, 10:06 PM
  4. Replies: 4
    Last Post: 09-14-2011, 06:23 PM
  5. Adding Up Dollar Amounts?
    By NeighborMike in forum Excel General
    Replies: 1
    Last Post: 08-11-2009, 01:17 PM
  6. How do i convert a spreadsheet with dollar amounts to euros?
    By DeanaCraig in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2006, 01:58 PM
  7. [SOLVED] dollar amounts
    By acsnett in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-22-2005, 02:05 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