#TRANSFER! where and why? How to remove?

V

Vladyslav2021-10-26 00:51:02

excel

Vladyslav, 2021-10-26 00:51:02

Office 2021.
I was given an easy task, and have been trying to solve this problem for an hour now. Task - if there are no ratings (the range of cells is empty), then in the "Subject" cell there should be 0, if there are numbers there, then we calculate the average value. Of course, you already understood this from the formula, but the formula is not executed, because the transfer is going on ... How did it appear if I did not ask it. Cells blocked and nothing ... Really stupor. Thank you for your attention!

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Saboteur, 2021-10-26
@lmoodl

Task - if the cell is empty, then in the "Subject" cell

So you don't have a cell in your check, but a range of cells.
Use the COUNTBLANK formula to count the number of empty cells in a range. And if it is greater than zero, then 0, if it is less then count:
=IF(COUNTBLANK(C3:H3)>0,"0",AVERAGE(C3:H3))