Results 1 to 3 of 3

Return address of next value in list which doesn't match criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-19-2010
    Location
    Huddersfield, UK
    MS-Off Ver
    Excel 2007, 2010
    Posts
    167

    Return address of next value in list which doesn't match criteria

    Evening all - hope someone can help me with another head-scratcher!

    Book2.xlsx


    I want to sum the numbers in colB for each of the headings (the yellow cells). So the first sum would be of B1:B7, the next B9:B11 etc. I need this formula to automatically work out for itself the correct range to sum for each heading though, as the headings and number of corresponding fields underneath may vary. All fields will all start 'UK' though - that is the only constant.

    I started working on making a formula to find the next row down that did not contain 'UK', and create a range based on that, but I just couldn't get it to work...

    Hoping I've explained myself well enough for someone to help!

    Thanks in advance
    Last edited by dancing-shadow; 10-20-2015 at 05:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] For a multi-criteria match, return the value closest to current value in list
    By FraserMBrowning in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2015, 06:16 AM
  2. [SOLVED] Need a formula to return the value in the Address column if 3 other criteria are met...
    By Stanimal in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-04-2015, 08:10 PM
  3. [SOLVED] Add row for item that doesn't match to the list and add value if match
    By dondonordas in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 02-17-2014, 08:37 PM
  4. Replies: 2
    Last Post: 09-28-2013, 03:39 PM
  5. Replies: 17
    Last Post: 09-17-2012, 07:44 AM
  6. Replies: 6
    Last Post: 04-11-2012, 01:07 PM
  7. Return range address by criteria
    By ScottStevo in forum Excel General
    Replies: 6
    Last Post: 05-12-2011, 10:38 AM

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