Using a row value criteria in an averageifs function

Hi, I am trying to create a formula that takes in a range of cells and averages the cells in that range that have a value >=0% and row number >= a number stored in another cell. Is this possible? I a...

excel

Formulas and Functions

Twifoo
Aug 01, 2019
nickaho
It would be best if you store your variables in Cells. For example, if the values are in Column A, the Start Row is stored in C2, End Row in C3, and Percent in C4, then the formula to return your desired result would be:
=AVERAGEIF(INDEX(A:A,C2):INDEX(A:A,C3),
">="&C4)

Forum Discussion

Using a row value criteria in an averageifs function

Resources