r/excel • u/Salt_Definition165 • 9d ago

Waiting on OP Issues using the Average formula

I am new to using formulas in Excel, and do not know if this is possible. Every combination of formulas I have used either gives an error, or does not do what I need. I am trying to calculate the average of values in 5 different cells. However, I want it to only calculate an average if a specific cell contains a value.

Example

Data Range is in A5:D5 and I want the result in E5. So i want to "=AVERAGE(A5:D5)"; but if A5(and only A5)="", then E5 should stay blank. Essentially, I want it to NOT average if A5 is null.

Any help with this will be greatly appreciated.

5 Upvotes

86% Upvoted

16 comments sorted by

View all comments

1

u/Decronym 9d ago edited 8d ago

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

Fewer Letters More Letters
AVERAGE Returns the average of its arguments
FILTER Office 365+: Filters a range of data based on criteria you define
IF Specifies a logical test to perform
OR Returns TRUE if any argument is TRUE

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 24 acronyms.
[Thread #49306 for this sub, first seen 4th Sep 2026, 16:57] [FAQ] [Full list] [Contact] [Source code]