Hey,

Sorry for asking, this should really be a straight forward case to solve myself, tho being an Excel newb with functions, I failed.

So here is my case:

The picture below is way simplified, however it explains my problem. As you can see, I'd like to count up the "Status x" linked to the ID, and sum it all up in the table to the right. So in the left there is a long list of statuses connected to the IDs, and summed up.

This would be the case for "ID"=9

Status 1 Status 2 Status 3 Status 4
9 4 3 0 1


hb73JrL.png