+ Reply to Thread
Results 1 to 4 of 4

Increase value in quotation marks in successive rows

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2

    Increase value in quotation marks in successive rows

    I'm new to these forums. I've googled extensively but can't find the answer to my problem, so hoping someone here will be able to help!

    I'm currently using the countifs function to help in a project as follows:

    =COUNTIFS(Sheet1!AM:AM,"0",Data!K:K,"Accepted")
    Where the number 0 here represents the number of days since the project started. With subsequent rows, I need this figure to increase by 1, all the way up to 365.

    Unfortunately just dragging down doesn't change values within quotation marks. Does anyone know a way to solve this issue? I have several columns with similar formulae, so individually typing the values would take far too long!

    Thank you in advance!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,240

    Re: Increase value in quotation marks in successive rows

    Firstly, why does the 0 need to be in quotation marks? Secondly, will this be dragged down only 365 rows?

    =COUNTIFS(Sheet1!AM:AM,rows($A$1:$A1)-1,Data!K:K,"Accepted")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-29-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Increase value in quotation marks in successive rows

    Thank you!

    For some reason I thought it needed to be in quotation marks! Feel a bit silly, but your formula works perfect. 365 rows, and similar formulae for about 40 columns.

    Thanks again

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,240

    Re: Increase value in quotation marks in successive rows

    You're welcome!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Can I export rows of text to a .sas file WITHOUT quotation marks?
    By pehsh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2016, 01:26 PM
  2. Quotation Marks Getting in the Way
    By Vladamir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2012, 06:50 PM
  3. Quotation Marks?
    By LinearChaos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2006, 05:37 PM
  4. without quotation marks?
    By jfazz in forum Excel General
    Replies: 1
    Last Post: 03-02-2006, 12:45 PM
  5. Quotation Marks - When and What??
    By heski in forum Excel General
    Replies: 2
    Last Post: 02-07-2006, 08:45 AM
  6. [SOLVED] quotation marks
    By JohnF in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-05-2006, 05:35 PM
  7. quotation marks
    By Hippy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2005, 07:10 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