+ Reply to Thread
Results 1 to 15 of 15

Issues with dragging formula down after multiple range of cells are referenced

Hybrid View

  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Issues with dragging formula down after multiple range of cells are referenced

    =COUNTIFS(A:A,A2,C:C,">=3")

    If not, please add some expected results.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  2. #2
    Registered User
    Join Date
    12-14-2021
    Location
    Bangkok
    MS-Off Ver
    MS Office 365, Verision 16.55
    Posts
    62

    Re: Issues with dragging formula down after multiple range of cells are referenced

    Thanks but I am not counting anything here, I am returning the value of 0 or 1 based on condition. The expected the results and the formula I am using is already there in the sheet (COLUMN D) which I have already mentioned.. The issue here is I can't drag the formula cause its a spill

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dragging cells to other referenced cells gives REF ERROR.
    By iturriko in forum Excel General
    Replies: 2
    Last Post: 11-29-2018, 10:00 AM
  2. Getpivotdata - dragging issues
    By NoWizkid in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-30-2018, 10:02 AM
  3. [SOLVED] Dragging cells changes range in formula of locked cell; can I prevent this?
    By exceln00b22 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2014, 08:19 PM
  4. Replies: 1
    Last Post: 04-30-2012, 10:01 PM
  5. Dragging Formulas - Skipping Referenced Cells
    By markpratt in forum Excel General
    Replies: 2
    Last Post: 11-03-2011, 10:03 AM
  6. Dragging & Dropping a range of cells
    By mge in forum Excel General
    Replies: 7
    Last Post: 11-02-2010, 04:48 AM
  7. Replies: 3
    Last Post: 08-18-2005, 11: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