Use this expression:
array_sum(
array_foreach(
string_to_array(
"list_of_polygons" ,
','
),
attribute(
get_feature(
@layer,
'name',
@element
),
'area'
)
)
)