+ Reply to Thread
Results 1 to 2 of 2

Summing and dividing numbers

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    1

    Summing and dividing numbers

    Hi,

    I am trying to get a qualified percentage from the following data. Column "Step" always changes, as in, it can be shorter, longer, more or less "steps" can be in this column. I want to get a qualified percentage by dividing the "No data Entry Required" + "Entered in SE/Client ATS" / "sourced". The data is attached and

    Any suggestions...


    Step 7/29/2012 8/5/2012 8/12/2012 8/19/2012 8/26/2012 Total
    Sourced 20 5 20 32 12 89
    Sourced Candidate Submitted to CFR 8 0 20 8 7 43
    No Data Entry Required 0 0 7 0 3 10
    Entered in SE/Client ATS 0 8 0 0 0 8
    Total 28 13 47 40 22 150
    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,926

    Re: Summing and dividing numbers

    Please look up the SUM and division in Help.

+ 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