+ Reply to Thread
Results 1 to 10 of 10

Index: Return Total Number of Items in a Range

  1. #1
    Registered User
    Join Date
    09-16-2018
    Location
    British Columbia
    MS-Off Ver
    2013
    Posts
    6

    Index: Return Total Number of Items in a Range

    excel, return total value.jpgexcel, return total value2.jpg

    I am trying to return the total number of domains I own for each niche, for example "Weight Loss" or "Travel".

    I decided to use the index & match function to avoid the limitations of vlookup.

    I have the formula returning a value of 1 currently but I know the correct answer is 7.

    Anyone else see what I have wrong here or am missing? So close, yet so far.

    Thanks.excel, return total value.jpg

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Index: Return Total Number of Items in a Range

    Try it this way:

    =COUNTIF(Nucleus!CC30:CC257,E47)

    In future it would be better to attach a sample Excel workbook, rather than a picture of one.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    09-16-2018
    Location
    British Columbia
    MS-Off Ver
    2013
    Posts
    6

    Re: Index: Return Total Number of Items in a Range

    Exce||enta Amigo! Mu˘hos Gracias.

    I didn't know about countif and countifs. I bet it can help automate my job a bit more. *Eurčka Moment*.
    Have you done any cool stuff with countif? Magnus Opus type stuff?

    Thanks for the "upload excel sheet" pov, duh? lol...my bad =0)

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Index: Return Total Number of Items in a Range

    Glad it worked for you. COUNTIF is a very useful function, so it is worthwhile to get to know it (plus COUNTIFS, SUMIF, SUMIFS etc.)

    Thanks for the rep. If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

    Pete

  5. #5
    Registered User
    Join Date
    09-16-2018
    Location
    British Columbia
    MS-Off Ver
    2013
    Posts
    6

    Re: Index: Return Total Number of Items in a Range

    10-4
    thanks again, I look forward to contributing in this forum, this forum has helped me alot over the years when i have been mentally bottleneck stuck on something i find frustrating, i come here to find the answer =0)

  6. #6
    Registered User
    Join Date
    09-16-2018
    Location
    British Columbia
    MS-Off Ver
    2013
    Posts
    6

    Re: Index: Return Total Number of Items in a Range

    I am Seriously, trying to find the place to mark the thread as solved. Miss fire. No luck. over. Appologies

    excelforums_whereisthesolverofthethingstomarksassolved.jpgexcel, forums, huh.jpg

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Index: Return Total Number of Items in a Range

    I have marked it SOLVED for you.

    The image you show is not the same as what I see at the top of the page. Are you on a pc, mac or phone?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Registered User
    Join Date
    09-16-2018
    Location
    British Columbia
    MS-Off Ver
    2013
    Posts
    6

    Re: Index: Return Total Number of Items in a Range

    Thanks,
    Windows 10 desktop, Firefox 62.0

    I like the tech on this site btw! great job! excellent work.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Index: Return Total Number of Items in a Range

    OK another member (davesexcel) pointed me in the right direction. You are in the "My Posts" screen, not in the thread itself.

  10. #10
    Registered User
    Join Date
    09-16-2018
    Location
    British Columbia
    MS-Off Ver
    2013
    Posts
    6

    Re: Index: Return Total Number of Items in a Range

    ahh 10-4
    bingo.jpg

    10-4 Got it, thanks dave!
    for me that required narrow System2 focus,
    humanbrain.jpg

+ 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. Index Match Return Value based on two variables and number range
    By nickymac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2018, 07:05 AM
  2. Replies: 6
    Last Post: 11-15-2015, 04:53 PM
  3. Help with Index/Match Formula-two conditions and return multiple items
    By bigermac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2015, 11:06 AM
  4. [SOLVED] counting the total number of items which are ordered
    By ImTr0uBLe in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-16-2015, 12:03 PM
  5. getting total number of items sold from a list
    By rchapman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2014, 06:42 AM
  6. Total return index Bonds
    By stianabra in forum Excel General
    Replies: 1
    Last Post: 06-23-2012, 01:36 AM
  7. [SOLVED] How do I get the total number of items that meet 2 criteria in Exc
    By Terri in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2006, 05:55 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