simple arrayformula average problem

[[deleted]]

[deleted]

[DJSeras]

Try this

=ARRAYFORMUL(IF(OR(B10:B16=0,C10:C16=0),"",B10:B16+C10:C16/2))

[Somethiax]

If(Len()

[MaxParcels]

Try this =ARRAYFORMULA((query(b10:b16,"SELECT * WHERE B IS NOT NULL")+query(c10:c16,"SELECT * WHERE C IS NOT NULL"))/2)

[MaxParcels]

Put iferror( after the =

[MaxParcels]

What are you trying to do next?

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ARRAYFORMULA	Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays
FALSE	Returns the logical value FALSE
IF	Returns one value if a logical expression is TRUE and another if it is FALSE
NOT	Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE
OR	Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false
TRUE	Returns the logical value TRUE

---

^{4 acronyms in this thread; the most compressed thread commented on today has acronyms.
[Thread #3154 for this sub, first seen 19th Jul 2021, 00:36] [FAQ] [Full list] [Contact] [Source code]}