• 462K Members
• 7,063 Online
• 559K Conversations
SOLVED

New Contributor

# 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 am trying to make use of averageif(s) function, but can not figure out how to make use of the row() function nested within. Really appreciate the help!

6 Replies

# Re: Using a row value criteria in an averageifs function

My recommendation for you to get an answer is to provide sample data in an Excel file.

Highlighted

# Re: Using a row value criteria in an averageifs function

If your data is in column A and row number to start is in C1, when like

``=AVERAGEIF(INDEX(A:A,\$C\$1):A1000,">=0")``

assuming you are within 1000 rows range

Solution

# Re: Using a row value criteria in an averageifs function

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)

# Re: Using a row value criteria in an averageifs function

@Sergei Baklan Thank you! This is perfect

# Re: Using a row value criteria in an averageifs function

@Twifoo Awesome, thank you so much!

# Re: Using a row value criteria in an averageifs function

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies