+ Reply to Thread
Results 1 to 3 of 3

Multiple Y/N option formula issues. T-shirt cost calculator for small business IF/VLOOKUP?

  1. #1
    Registered User
    Join Date
    05-12-2015
    Location
    Birmingham
    MS-Off Ver
    2011
    Posts
    12

    Multiple Y/N option formula issues. T-shirt cost calculator for small business IF/VLOOKUP?

    Hello,

    Were looking to make a spreadsheet that will work out how much vinyl we need for a run of prints

    I'm not sure if we should use an IF function or a VLOOKUP function for this

    Basically we would like the formula that will look down our A column, spot all of the "y"s and give us the SUM of the corresponding cells in the E column. Only the ones with the "Y", if "N" shows it should just be ignored

    Is this possible and if so how would i go about constructing the formula?

    Ive attached a photo of the spreadsheet for your reference

    Screen Shot 2015-05-12 at 15.22.32.png

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Multiple Y/N option formula issues. T-shirt cost calculator for small business IF/VLOO

    To Get the Count

    =COUNTIFS(A:A,"Yes",E:E,"<>"&"")


    To Get the Sum

    =SUMIF(A:A,"Yes",E:E)


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    05-12-2015
    Location
    Birmingham
    MS-Off Ver
    2011
    Posts
    12

    Re: Multiple Y/N option formula issues. T-shirt cost calculator for small business IF/VLOO

    Thanks alot guys the SUM IF function worked perfectly

+ 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. Cost calculator
    By chairmaker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2015, 08:51 AM
  2. Replies: 2
    Last Post: 02-23-2015, 05:26 PM
  3. Replies: 1
    Last Post: 09-14-2012, 02:18 PM
  4. Help with multiple issues in my Excel calculator
    By KevAquarius in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2011, 06:39 PM
  5. Cost Calculator
    By bnwash in forum Excel General
    Replies: 1
    Last Post: 04-20-2007, 05:08 AM

Tags for this Thread

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