+ Reply to Thread
Results 1 to 2 of 2

How can I auto-fill a COUNTIFS function?

  1. #1
    Registered User
    Join Date
    07-10-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    16.16.5
    Posts
    1

    How can I auto-fill a COUNTIFS function?

    Hello,
    I have several massive spreadsheets that I need to analyze using the COUNTIFS function, but right now the only way I know how to do that is by changing the data range for each cell. For example, I am using the function =COUNTIFS(A:A,">0",A:A,"<5") for the first cell, and then =COUNTIFS(A:A,">5",A:A,"<10"), =COUNTIFS(A:A,">10",A:A,"<15") and so on. Is there a way do it so I could just specify to count every 5, and excel would autofill 0-5, 5-10, 10-15, etc.?
    Excel screenshot.jpg

    Thank you!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: How can I auto-fill a COUNTIFS function?

    Please Login or Register  to view this content.
    Ben Van Johnson

+ 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 there a formula/function to auto fill numbers?
    By Jessica at Heritage in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-24-2017, 11:54 AM
  2. Auto-fill function
    By jkhoury1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2017, 11:42 AM
  3. Auto-fill collumn with SUM function
    By NickyWalraven in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2013, 02:48 PM
  4. auto fill function or formula
    By nmss18 in forum Excel General
    Replies: 3
    Last Post: 03-04-2011, 11:28 AM
  5. Auto Fill Text With counting Function
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2010, 05:31 PM
  6. Regulating auto fill-in function
    By wasureta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2008, 10:06 AM
  7. Looking for a function for auto-fill template
    By Thelonious_Monk in forum Excel General
    Replies: 3
    Last Post: 08-23-2007, 03:13 PM

Tags for this Thread

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