Results 1 to 8 of 8

Countifs with nest left

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-11-2013
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    270

    Countifs with nest left

    hi im trying to do a count if with two dates, but i need to add a left formula and the dates im counting has a time after it and the date im using as a reference doesnt.

    Here my formula which would work if the dates im looking up didnt have time in the same cell.

    =COUNTIFS($A:$A,H3,$B:$B,H3,$C:$C,I3)

    I have also attached the example.

    I know how to do left and right but i dont know where to put it within a formula.
    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] How to nest a left function within a sumif function?
    By LisaK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2017, 09:21 AM
  2. [SOLVED] Nest LEFT in VLOOKUP producing error
    By msawyer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-07-2012, 07:26 PM
  3. [SOLVED] Excel 2007 : COUNTIFS with LEFT - workaround needed
    By dip11 in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 09:24 AM
  4. HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
    By CHAIM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
    By CHAIM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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