Formula

=CONCAT ( "Stupci P i Q - Stanje: " ; TEXT ( SUM (P105:P107) ; "[$$-en-US]#.##0,00") ; " ... (" ; TEXT ( SUM (Q105:Q107) ; "[$$-en-US]#.##0,00") ; ")" )

Rezultat

Stupci P i Q - Stanje: $1,234 ... ($2,345)

excel concat xexcel xconcat