Average the entries that meet the threshold. Follow a five-row recipe portions example with the exact formula and an expected result. This worked guide uses a small reproducible example so you can check the result before adapting it to your own task.
Before you start
- A spreadsheet application supporting the listed functions, such as current Excel or Google Sheets
- A blank worksheet
- Five sample rows; no private information is needed
Step-by-step guide
Create a small sample table
Open a blank worksheet. Enter these labels in column A and numbers in column B. Keep the header in row 1 and the five observations in rows 2–6.
A1: Recipe | B1: Servings
A2: Soup | B2: 4
A3: Pasta | B3: 6
A4: Salad | B4: 2
A5: Rice | B5: 5
A6: Stew | B6: 8
Keep the inputs numeric
Select B2:B6 and use a plain Number format. Enter only the number in each cell; put the unit, servings, in the header. A value such as "4 servings" is text and can change what numeric formulas include.
Enter the formula in a separate cell
Click D2 and type this formula, including the initial equals sign. Press Enter. Average the entries that meet the threshold. Use ordinary straight quotation marks in formulas; typographic quotation marks are not valid formula delimiters.
=AVERAGEIF(B2:B6,">=10",B2:B6)Check the worked result
With the sample data exactly as shown, D2 should return #DIV/0!. If the result differs, compare the cell references and make sure the formula covers rows 2–6. Decimal results may be displayed with fewer decimal places depending on the cell format.
Adapt the range and verify a real row
Replace the sample with your own recipe portions only after the worked result matches. Expand B2:B6 and A2:A6 together when adding rows. Check one observation and one final result manually before using the worksheet.
Tips & troubleshooting
- These examples use comma argument separators. Some regional settings require semicolons instead.
- Use straight quotes, and preserve absolute references marked with $.
- Percentage formulas return fractions; apply a Percentage format when that display is appropriate.
Common questions
Why does the spreadsheet show the formula instead of a result?
Change the cell format from Text to General, edit the formula, and press Enter again. Make sure the first character is =.
Can I use more than five rows?
Yes. Extend every related range to the same final row and test the result against a small subset first.
