Hoopsah
08-23-2013, 03:38 AM
Hi,
looking for a formula that will help me do a couple of Sums for region of values.
Attached is a spreadsheet where I have done a sumproduct to count the instances of a code, between 2 numbers, but in the next 2 tables I am looking for a code that will –
Table 1: If the code is in column A then cost in column D, (E then H, I then L and M then P) and copy this across the line, but only if it is between the 2 codes mentioned.
Table 2 - If the code is found anywhere along the line then give the total sum that is in column.
All help appreciated
looking for a formula that will help me do a couple of Sums for region of values.
Attached is a spreadsheet where I have done a sumproduct to count the instances of a code, between 2 numbers, but in the next 2 tables I am looking for a code that will –
Table 1: If the code is in column A then cost in column D, (E then H, I then L and M then P) and copy this across the line, but only if it is between the 2 codes mentioned.
Table 2 - If the code is found anywhere along the line then give the total sum that is in column.
All help appreciated