Results 1 to 12 of 12

Countif with multiple criteria and calculations

Threaded View

tinytutu Countif with multiple... 05-13-2016, 06:02 PM
zbor Re: Countif with multiple... 05-13-2016, 06:07 PM
tinytutu Re: Countif with multiple... 05-13-2016, 06:09 PM
zbor Re: Countif with multiple... 05-13-2016, 06:15 PM
zbor Re: Countif with multiple... 05-13-2016, 06:29 PM
tinytutu Re: Countif with multiple... 05-13-2016, 06:39 PM
zbor Re: Countif with multiple... 05-13-2016, 06:41 PM
tinytutu Re: Countif with multiple... 05-13-2016, 07:06 PM
JeteMc Re: Countif with multiple... 05-14-2016, 12:02 AM
tinytutu Re: Countif with multiple... 05-20-2016, 02:39 PM
zbor Re: Countif with multiple... 05-14-2016, 01:58 AM
JeteMc Re: Countif with multiple... 05-20-2016, 04:34 PM
  1. #1
    Registered User
    Join Date
    11-16-2013
    Location
    Belfast
    MS-Off Ver
    Excel 2010
    Posts
    25

    Countif with multiple criteria and calculations

    Hello,

    I'm trying to use Countifs to compare each cell to multiple columns, sometimes involving calculations within those comparisons. I'm trying to find out who earns less than a specified differential per year of service. I've attached my Excel file and will explain it here:

    For example, the first entry is Alpha A (job title and grade) and earns $3750 with 11 years of service. The second entry is also an Alpha A but earns $3700 with only 5 years of service. As specified in H2, each year of service should bring a salary differential of 1%. So the first Alpha A should be earning at least 6% (1% X 6 years) more than the second Alpha A, but actually earns only 1.35% ($50) more. So the count in F2 should be "1" meaning there is one person who earns more than that individual based on the rule (1% per years of service).

    Here's what my formula looks like in theory (obviously doesn't work because I'm subtracting with ranges): countifs($A:$A,$A2,$B:$B,$B2,$D:$D>$D2,$C:$C>($C2/($H$2*($E2-$E:$E))))

    I'm trying to avoid array formulas because my file is very large. I'm not sure if Countif is even the best formula to be using.

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] multiple criteria for calculations
    By tsh1586 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 05-06-2014, 05:22 PM
  2. Countif, Multiple Criteria, Multiple Sheets, Excel 2003
    By shyammankoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2013, 06:50 AM
  3. [SOLVED] trying to do a "countif" with multiple ranges and multiple criteria. Countif, Sumproduct?
    By completelyhis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 06:12 PM
  4. Trying to COUNTIF when multiple criteria are met on multiple column data set
    By TGCRequiem in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-15-2011, 12:58 AM
  5. using countif with multiple corresponding criteria
    By macmandan1 in forum Excel General
    Replies: 5
    Last Post: 02-15-2010, 09:51 PM
  6. [SOLVED] Countif w/ Multiple Criteria-How do I use countif
    By Patrick_KC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 05:05 PM

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