+ Reply to Thread
Results 1 to 2 of 2

IF statements:Need some help with a formula.

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Houston, Tx
    MS-Off Ver
    Excel 2013
    Posts
    43

    IF statements:Need some help with a formula.

    Hi!

    I have no idea how to create a certain formula. I need to ultimately find the percentage of people in the same business sitting on a floor in a building. For example:

    If the business is "Controllers" then I need to know out of all the controllers what is the percentage of them that sit on floor 4 of BP1.
    There are several different floors, buildings, and businesses. I need to be able to calculate this for all businesses.

    I appreciate any help or advice I can I get. I am attaching a small portion of my document so you can kind of see the data I am working with.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,622

    Re: IF statements:Need some help with a formula.

    One way:

    =COUNTIFS($A:$A,$A2,$B:$B,$B2,$C:$C,$C2)/COUNTIF($A:$A,$A2)

    formatted as a percentage.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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