+ Reply to Thread
Results 1 to 3 of 3

Need help to Filter results from a colounm which has a certain list choosen

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    7

    Need help to Filter results from a colounm which has a certain list choosen

    Hi there,

    I am currently working on a time sheet to give me results of the total time taken to read certain platforms


    I have a list option in column B which gives me the option to select Facebook or email

    In column F i have the total time taken to read the email , which is a simple formula with final time stamp minus time stamp in column A

    I therefore have a mixture of outcomes in column B and a mixture of total times in column F

    What I need is a formula which will take all the time totals in column F , which relate to facebook and then another Cell which will give a total time for emails ..

    Is this possible and can someone help create this ???

    hope this make sense

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need help to Filter results from a colounm which has a certain list choosen

    =sumif($B$1:$b$50,"facebook",$f$1:$f$50)

    you could do the same for email
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    09-03-2014
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    7

    Re: Need help to Filter results from a colounm which has a certain list choosen

    Cheers oeldere

    It worked a treat... and I understand it

+ 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. Label Filter Pivot Results by Defined List
    By scottyedmonds in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-28-2014, 12:20 PM
  2. Filter List Results Dependent on another Filter List
    By Owlsfan in forum Excel General
    Replies: 2
    Last Post: 04-28-2013, 06:20 PM
  3. Automatically filter? to list multiple results
    By matt2 in forum Excel General
    Replies: 4
    Last Post: 03-29-2010, 01:11 PM
  4. Results of List of Data with Advanced Filter
    By vtphilk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2008, 06:21 PM
  5. Replies: 2
    Last Post: 08-18-2006, 05:28 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