+ Reply to Thread
Results 1 to 5 of 5

Iterative Formula

Hybrid View

  1. 01-29-2016, 08:22 PM #1
    kathrynreno
    kathrynreno is offline
    Registered User
    Join Date
    01-29-2016
    Location
    Reno, Nevada
    MS-Off Ver
    14.6
    Posts
    2

    Iterative Formula

    I'm trying to write a formula that is infinite to add all new data from a Google Form. The snag is that I'm turning text into numbers.

    For example, I want the formula to search the column for the text "Youth 1" and add up all occurrences. Then I will do the same for "Youth 2," "Youth 3," etc. in other cells.

    Here's what I have:

    =(IF ('Form Responses 1'!B2 = "Youth 1",1,0))+(IF ('Form Responses 1'!B3 = "Youth 1",1,0))+(IF ('Form Responses 1'!B4 = "Youth 1",1,0))

    This works, but is there something I can do to not repeat this formula over and over again? I tried

    =SUM (IF ('Form Responses 1'!B2:B1000 = "Youth 1",1,0)) and other variations of that, but nothing seems to be working.

    Any help would be appreciated! Thank you!
    Reply With QuoteRegister To Reply
  2. 01-29-2016, 08:54 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,102

    Re: Iterative Formula

    Use SUMIF, not SUM(IF(


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-29-2016, 08:57 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,102

    Re: Iterative Formula

    Or, actually, what you need is COUNTIF.

    Formula: copy to clipboard 
    =COUNTIF(B1:B1000, "youth 1")



    Regards, TMS
    Reply With QuoteRegister To Reply
  4. 01-29-2016, 09:05 PM #4
    kathrynreno
    kathrynreno is offline
    Registered User
    Join Date
    01-29-2016
    Location
    Reno, Nevada
    MS-Off Ver
    14.6
    Posts
    2

    Re: Iterative Formula

    That worked! Thank you!
    Reply With QuoteRegister To Reply
  5. 01-29-2016, 09:23 PM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,102

    Re: Iterative Formula

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help with iterative Debt to Capital formula
    By AudiR8dreamer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2015, 11:36 AM
  2. Create an iterative formula
    By leonszlez in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 06:12 PM
  3. iterative function
    By mt45 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2011, 06:04 PM
  4. Iterative Charting
    By shaunsul in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-25-2011, 03:33 PM
  5. Iterative method
    By ya7omar in forum Excel General
    Replies: 2
    Last Post: 11-03-2009, 03:29 AM
  6. Iterative Formula
    By Phil_V in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2009, 08:54 AM
  7. [SOLVED] Iterative process,
    By bioyyy in forum Excel General
    Replies: 5
    Last Post: 11-30-2005, 10: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1