waterconsultant
New Member
- Joined
- Oct 18, 2016
- Messages
- 18
Hi Folks, probably trivial, but not familiar with non-sequential ranges. Assuming I have 2 columns, X and Y, with 5 rows of data, 1 to 5. Col X is the lookup range, Col Y is the sum range. If the criteria in lookup range is "A2", and this occurs on e.g. row 2 and row 5, then obviously =SUMIF(X1:X5,"A2",Y1:Y5) produces the correct result finding the associated values in col Y.
BUT in my case the sum range is NOT sequential, and is elsewhere. For example, let's say the values all occur in column F, but now have multiple rows between the lookup values i.e. the 5 potential lookup values occur on row 7, 14, 21, 28, 35? How to access THAT 'range'? (There will always be a fixed number of interval rows, if that helps). I tried giving the non-sequential lookup range a NAME, as in SUMIF(X1:X5,"A2",rangename) but no joy.
Thanks in advance!
waterconsultant
BUT in my case the sum range is NOT sequential, and is elsewhere. For example, let's say the values all occur in column F, but now have multiple rows between the lookup values i.e. the 5 potential lookup values occur on row 7, 14, 21, 28, 35? How to access THAT 'range'? (There will always be a fixed number of interval rows, if that helps). I tried giving the non-sequential lookup range a NAME, as in SUMIF(X1:X5,"A2",rangename) but no joy.
Thanks in advance!
waterconsultant