+ Reply to Thread
Results 1 to 2 of 2

Is there a quick way to copy this down

  1. #1
    Registered User
    Join Date
    07-22-2017
    Location
    australia
    MS-Off Ver
    365
    Posts
    41

    Is there a quick way to copy this down

    =(COUNTIFS(Sheet1!D8:R8,$G$2,Sheet1!D6:R6,$F$2)+COUNTIFS(Sheet1!D8:R8,$G$2,Sheet1!D7:R7,$F$2)+COUNTIFS(Sheet1!D13:R13,$G$2,Sheet1!D11:R11,$F$2)+COUNTIFS(

    =(COUNTIFS(Sheet1!D20:R20,$G$2,Sheet1!D18:R18,$F$2)+COUNTIFS(Sheet1!D20:R20,$G$2,Sheet1!D19:R19,$F$2)+COUNTIFS(Sheet1!D25:R25,$G$2,Sheet1!D23:R23,$F$2)+COUNTIFS(Sheet1!D27:R27,$G$2,Sheet1!D26:R26,$F$2))/2

    i need it to fill a Monday to sunday 7 rows

  2. #2
    Registered User
    Join Date
    07-22-2017
    Location
    australia
    MS-Off Ver
    365
    Posts
    41

    Re: Is there a quick way to copy this down

    Copy the formula down?
    Attached Files Attached Files

+ 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] Is ther a quick way to copy this down?
    By dmillsmartclean in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2017, 01:20 PM
  2. How to consolidate different sheets into one
    By keychain in forum Excel General
    Replies: 3
    Last Post: 01-29-2016, 01:16 AM
  3. Copy Paste Transpose Quick Way
    By dramachines in forum Excel General
    Replies: 2
    Last Post: 06-05-2015, 01:10 PM
  4. Quick Vba question to copy from the last row to the second row of the data
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2014, 12:51 PM
  5. I'm looking for a quick way to copy data from one worksheet to another
    By robjbc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2012, 11:58 AM
  6. [SOLVED] Quick Copy
    By JokerDan22 in forum Excel General
    Replies: 1
    Last Post: 10-12-2012, 10:46 AM
  7. Quick Copy
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2005, 12:21 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