Average non empty cells

Question

Average non empty cells

LS T 80

How to average non empty cells?

Should I use AVERAGEIF function?

LS T 80 Reputation points

2023-03-31T15:54:45.33+00:00

I tried the formula: =AVERAGEIF(B4:B13,"<>0",C4:C13), not working... Please help!
Viorel 125.8K Reputation points

2023-04-02T14:51:28.94+00:00

AVERAGE seems to ignores empty cells. Probably you want to ignore the cells that contain 0. What issue are you experiencing with your formula? Show details about the B and C columns. Maybe you should write =AVERAGEIF(C4:C13,"<>0")?

Answer accepted by question author

0 additional answers

Your answer

LS T 80 Reputation points

2023-03-31T15:54:45.33+00:00

I tried the formula: =AVERAGEIF(B4:B13,"<>0",C4:C13), not working... Please help!
Viorel 125.8K Reputation points

2023-04-02T14:51:28.94+00:00

AVERAGE seems to ignores empty cells. Probably you want to ignore the cells that contain 0. What issue are you experiencing with your formula? Show details about the B and C columns. Maybe you should write =AVERAGEIF(C4:C13,"<>0")?

Answer 1

Emi Zhang-MSFT 30,126 Microsoft External Staff

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.

Share via

Average non empty cells

0 additional answers

Your answer