Sum the costs in the text using SUM + Iferror

💥My boss asked me to sum the costs, but the costs are mixed with text?

😮‍💨Still calculating them one by one?

Using the SUM function directly definitely won't work.

Then use the SUM + IFError function to get it done immediately!

🧠 Amazing Technique: SUM+IFERROR

Assuming the data is as follows: 👉 Cost = E4

I directly input:

=SUM(IFERROR(TEXTSPLIT(E4,{" ",","}, ,TRUE)*1,0))

✨ In just one second, Excel automatically calculates the cost in the text.

🪄 Even better:

If there are any additional costs or changes to the cost,
Excel will automatically update. 😎

🌿 Clara's quote: "If it can be done in 1 second, don't spend 10 minutes on it." 💬 "SUM+IFERROR is the real time machine for working people."

SUM+IFERROR #excel #hrdcclaimable #excelformula #exceltips #excelfunction #excelshortcuts ClaraTeachExcel #exceltricks #excelfunctionsguide #excelfunctions #excelforbeginners #excelformulas #exceltipsandtricks #exceltipsandtricksguide #exceltricksandtips #exceltipstricks #hrdclaim #hrdc

Видео Sum the costs in the text using SUM + Iferror канала Excel Pro with Clara💚