The column chart in Excel

A specialist in creating column charts in Excel is required. You need to create a diagram in Excel. There is a table of training data. You need to make two column diagrams of the distance traveled for each name.
The table shows the names of the dogs vertically. There's a line at the top with the distance. The sign “+” in the table means that the distance is covered. The letter "l" means that the dog was the leader. We need to make two column charts. The first is the name of the dog and the distance traveled. I mean. We set a condition - if the cell is "+" or "l" then we sum up the distance traveled. The second diagram is the dog’s name and distance traveled in the leader position. I mean. Only those distances are summed up where the "l" sign stands in the cell. Table in the enclosure.