MATCH Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to use the MATCH function to return the value in a range that
meets a certain condition. For example, I would like it to look at the sum
of two cells across a number of columns and when the sum of those cells is
greater than 100 than return the position of that cell in the array. For
example, I would like to add the values of rows 10 and 15 across columns b -
f and when that sum is greater than 100 I would like the formula to return
the first position in the range for which that is true. So if the sum of c10
+ c15=105 the formula would return "2" since it is the second column in the
range that begins with "b". Thank you for your assistance.
 
=MATCH(TRUE,B10:F10+B15:F15>100,0)

This is an array formula, to be validated by Ctrl+Shift+Enter

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum last 3 numbers greater that 0 in a range 0
Excel Need Countifs Formula Help 0
Sumif number is greater than a number but less than another number 2
match function? 1
SumIFS Cell 1
Summing rows using formulas with variables 1
Array Function to do a Sum of VLookUps that translate a letter gra 3
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top