May 26 2021 03:20 AM
Buenos días.
En la columna C tengo una fórmula para calcular un promedio sobre las celdas donde hay números. Como en esas celdas tengo puesta una fórmula, no me calcula el promedio. Cuando le quito la fórmula y pongo yo los números, sí calcula el promedio.
¿Se puede solucionar?
Gracias.
May 26 2021 07:32 AM
En la columna C tengo una fórmula de promedio. En la otras tres tengo una fórmula de =SI(, respecto a la columna D.
May 26 2021 08:36 AM
May 26 2021 08:49 AM
SUMA(E7:G7;I7:K7;M7:O7;Q7:S7;U7:W7;Y7:AA7;AC7:AE7;AG7:AI7) returns a single value. There is no point in using PROMEDIO on a single number.
Does this do what you want?
=SI.ERROR(PROMEDIO(E7:G7;I7:K7;M7:O7;Q7:S7;U7:W7;Y7:AA7;AC7:AE7;AG7:AI7);"-")
May 26 2021 09:28 AM
May 26 2021 11:48 AM
Have you tried
=SI.ERROR(PROMEDIO(E7:G7;I7:K7;M7:O7;Q7:S7;U7:W7;Y7:AA7;AC7:AE7;AG7:AI7);"-")
Make sure that C7 (the cell with the formula) is not formatted as text.
May 26 2021 11:58 AM
May 26 2021 12:15 PM
It should be possible. Could you attach a sample workbook?
May 26 2021 01:24 PM
Yes please, you can attach it to a reply in this topic.
May 26 2021 09:47 PM
May 27 2021 02:43 AM
SolutionThank you! The problem is caused by the formulas in columns E:F, I:K and M:O.
For example in E7:
=SI.ERROR(SI(D7="MB";"10";SI(D7="B";"7,5";SI(D7="R";"5";SI(D7="M";"2,5";" "))));"")
The return values "10", "7,5" etc. are text because of the " ", not numbers! PROMEDIO ignores text values. It should be
=SI.ERROR(SI(D7="MB";10;SI(D7="B";7,5;SI(D7="R";5;SI(D7="M";2,5;""))));"")
See the attached version.
May 27 2021 04:15 AM
May 27 2021 02:43 AM
SolutionThank you! The problem is caused by the formulas in columns E:F, I:K and M:O.
For example in E7:
=SI.ERROR(SI(D7="MB";"10";SI(D7="B";"7,5";SI(D7="R";"5";SI(D7="M";"2,5";" "))));"")
The return values "10", "7,5" etc. are text because of the " ", not numbers! PROMEDIO ignores text values. It should be
=SI.ERROR(SI(D7="MB";10;SI(D7="B";7,5;SI(D7="R";5;SI(D7="M";2,5;""))));"")
See the attached version.