Collect and Sum from same ID in google sheet

  Kiến thức lập trình

I am an amateur on Google sheet.
I need help to sum up data with the same multiple ID.
I manage to make dropdown calculation, but somehow its too much work.
I want it summarized for me..
Can anyone help me?
enter image description here
I try to use sumifs
=SUMIFS(C4:C30;E4:E30;L4;D4:D30;K4)
Work ok, but then i have to select data i need all the time.
I want it summarized , I was thinking to use query , but i found it dificult, and fail all the time…

New contributor

Meylani Andersson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT