Dec 05 2021 06:09 AM
hi,
each time i refresh this query, the formulas in D6:v6 stop working.
=SUMAR.SI.CONJUNTO(Hoja1!$K:$K;Hoja1!$G:$G;$O$6;$D:$D;">1";$C:$C;">"&S2;$C:$C;"<"&U2)
can someone tell me why??
Thank you very much, Juan
Dec 05 2021 06:25 AM
SolutionColumn D is formatted as Text, so the values are treated as text, not as numbers.
Select column D.
Set the number format to General.
On the Data tab of the ribbon, click Text to Columns, then click Finish.
See the attached version.
Dec 05 2021 06:43 AM
Dec 05 2021 08:04 AM
Just changing the number format to General won't change the values. Text to Columns will convert the text values to numbers.
Dec 05 2021 06:25 AM
SolutionColumn D is formatted as Text, so the values are treated as text, not as numbers.
Select column D.
Set the number format to General.
On the Data tab of the ribbon, click Text to Columns, then click Finish.
See the attached version.