Results 1 to 6 of 6

COUNTIFS Problem has got me baffled...Please Help!

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2013
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2013
    Posts
    5

    Question COUNTIFS Problem has got me baffled...Please Help!

    Can someone please tell my why my formula works like:

    =COUNTIFS('Job Entry Form'!A:A,G6,'Job Entry Form'!K:K,">="&I6,'Job Entry Form'!K:K,"<="&J6,K:K,">=4",K:K,"<=7",'Job Entry Form'!J:J,"Yes")

    but not like:

    =COUNTIFS('Job Entry Form'!A:A,G6,'Job Entry Form'!K:K,">="&I6,'Job Entry Form'!K:K,"<="&J6,K6,">=4",K6,"<=7",'Job Entry Form'!J:J,"Yes")

    I am trying to get it to check a particular cell (K6) instead of the whole (K:K) column. I know this has to be possible, any help on what I'm doing wrong?

    It's on the "Running Log" page. I am trying to help my wife build a tool to help her keep track of her salesman's commissions and bonuses. It works for pulling the info she needs on a weekly basis, but I want to make a running total page for he as well, so I can make a reconcile page.

    Thanks in advance,
    David
    Attached Files Attached Files
    Last edited by ogbugsy; 12-23-2013 at 11:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Baffled by SumIf issue.
    By MLocke in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-02-2013, 03:31 PM
  2. [SOLVED] Excel 2007 : Baffled by the (lack of) result of a countif
    By neil40 in forum Excel General
    Replies: 1
    Last Post: 04-01-2012, 06:43 AM
  3. Strange Vlookup result - baffled
    By andycaps in forum Excel General
    Replies: 9
    Last Post: 01-18-2012, 08:58 AM
  4. Calculation in cell not updating - Totally baffled!
    By bmunoz64 in forum Excel General
    Replies: 1
    Last Post: 01-11-2012, 12:08 PM
  5. Replies: 0
    Last Post: 12-16-2011, 09:01 AM

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