Results 1 to 4 of 4

Countifs

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2011
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    78

    Countifs

    I am not able to work out how to count criteria (ie >0 and <$21.80 for Column H) against a series of ranges
    TO EXPLAIN FURTHER
    In Cell G289 I have put a count in for the entire column H, however this picks up some cells that I don’t want to count, SO…..
    In Cell H299 I have put a count in for the range of cells I need the count on - ie 7 days a week for 13 periods from 1/1/16 - 30/3/16. BUT
    that isnt working
    What I am trying to count is the number of days an employee has been paid less than the amount in row 10 but more than 0 (to remove the count on days he didn’t work)
    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] Countifs + Countifs - replacement?
    By JulieQ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2015, 03:02 PM
  2. [SOLVED] COUNTIFS that has if contains
    By jonathan.haynes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-28-2013, 06:01 AM
  3. COUNTIFS OR COUNTIFS needs to work
    By joshbellfi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2013, 10:55 AM
  4. COUNTIFS OR...multiple countifs without duplication in the numbers
    By HooligaD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 09:53 AM
  5. countifs
    By Loisw in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2012, 03:45 PM
  6. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  7. Countifs
    By KennyG in forum Excel General
    Replies: 8
    Last Post: 04-24-2010, 05:50 PM

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