I have two columns (Google Sheets) of numbers similar to:
10.453 12.178
12.654 0
The third column is:
- if number higher than
0exists in both columns, display an average of the two - else just display the one figure entered (in either column)
Google Sheets – Average Two Numbers if Second Exists
formulasgoogle sheets
Related Topic
- Google-sheets – How to sort in Google Sheets by cells containing section (or version) numbers
- Google-sheets – Highlight two numbers if they are different
- Google-sheets – ADD for more than two numbers in spreadsheet
- Google Sheets – How to Find Average of Difference Between Two Columns
- Google-sheets – How to do an aggregate function with multiple columns with a Google Sheets query
- Google Sheets – Return Closest Value from Two-Dimensional Data
- Google-sheets – Match similar values on another sheet by two values (date + number)
Best Answer
Another way of doing it, is by using the
AVERAGEIFformula.Formula
Screenshot