Share via

Average non empty cells

LS T 80 Reputation points
2023-03-31T15:53:04.6966667+00:00

How to average non empty cells?

Should I use AVERAGEIF function?

Microsoft 365 and Office | Excel | For business | Windows
Accepted answer
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2023-04-03T07:40:52.2966667+00:00

    Hi @LS T,

    Try this formula:

    =AVERAGEIF(A1:A9,"<>")

    User's image

    Hope it's helpful.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.