Return one numeric review mean for every record
Your goal: Use BYROW to reduce each three-review row, then keep the record labels beside the results with HSTACK.
Full task requirements
Enter one formula in G5 to return eight record labels and review means in G5:H12. Average only numeric B:D ratings for each source row. Zero is an observation; blanks and text, including text numbers, are ignored. A row with no numeric rating returns No observations. Keep source order and repeated labels.
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Choose numeric reviews in row 2
Rules for this step
Keep this record separate. Include numeric zero, ignore text numbers and blanks, and confirm an empty observation set when this row has no numeric ratings.
Tap values in the worksheet to include or remove them. Type labels distinguish stored numbers, text, logical values, genuine blanks and genuine errors.
Your selected values will appear here.
- Numeric observations
- 0
- Signed total
- 0
- Mean of this selection
- No observations