Does your data have NAs in it? if so, use na.rm = TRUE
.
df_grouped <- df_combi %>%
group_by(states) %>%
summarise(total_value = sum(col_lost, na.rm = TRUE))
If this doesn't solve your problem, please provide a proper REPRoducible EXample (reprex) illustrating your issue.