sum if multiple conditions are met, where order of numbers in array matters

**dilipandey** · 11-19-2012, 02:38 AM

Hi Kileyc,

Suggest you to look into SumIFs or Sumproduct function ... post the workbook in case of any issues, as suggested by Vinoth. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**kileyc** · 11-19-2012, 10:54 AM

Hi! Thank you both for your help. I attached a sample spreadsheet with some detail.

**kileyc** · 11-19-2012, 01:38 PM

Thank you again for your help! I'm sorry my example doesn't make much sense and the formula i tried to make in column q is incorrect.

If we use row 7 as an example, in column Q i'd like a to find the first number in row 7 that is larger than x, 500 --- in this case it is 3000. In row R I would like to find the first number in row that is larger then Y, starting to the right of the cell that contained the result of the first formula, so starting at C7 instead of B7. So in this case the result would be 800.

Thank you!