Sum of cells where the same cell contains both text and a formula

[Coastie]

I have retired and now use google sheets instead of excel, so I hope that's not the cardinal sin of MrExcel.

I am trying to add cells that have a text label and a value, Example.

Cell A1 = 2
Cell A2 = 4
Cell A3 = 6
Cell A4 = 8

Cell B2 = ="One  "&text(A1+A2, 0)
Cell B3 = ="Two  "&text(A2+A3, 0)
Cell B4 = ="Three "&text(A3+A4, 0)

Cells B2-B4 work fine, but I would like to add those cells together, I was hoping something like this would work, but it does not.

="Total  "&text(SUM(B2:B4), 0)

Looking for a total of 30.
Is there a simple way to do that?

 

[Fluff]

How about

="Total " &sum(ArrayFormula(SPLIT(B2:B4," ")))

 

[Coastie]

@Fluff That worked great, thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.