Selecting a Specific Column of a Named Range for the SUMIF Function
<p>I am trying to create a SUMIF function that dynamically adds up values in a <strong>specific column</strong> of a named range in my Excel sheet.</p>

<p>It is very easy to do this when there is no named range :</p>

<p><a href="https://i.stack.imgur.com/EIItD.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/EIItD.jpg" alt="enter image description here"></a></p>

<p>The formula picks out all the cells that contain "London" in their name and sums up the expenses related to London.</p>

<p>What I am trying to do is to use a named range called TripsData (A2:B5) and tell the SUMIF function to sum the entries in the column 2 of this range that meet the criterion of having London in their name. </p>

<p>How can I make this work without needing to create a second named range for column 2 and simply by telling Excel to look within the specified column of this named range? Index/Match only return one value so that doesn't work when there are several cells with London in their name.</p>

<p>Thanks for your help!</p>