Hello, I am trying to automatically consolidate the chart below into a second chart on the same sheet. In the left row wherever there is the same text, In this case Glyphosate in row 1 and 5 it would sum the corresponding value in column C. The consolidate function does what I need except the second chart I am trying to build is on the same sheet so I cant get it to update automatically if I change one of the numbers on the chart below, Thanks in advance
| Glyphosate | 0 | 6138.824588 |
| Conquer | 0 | 516 |
| Liberty | 0 | 2225.62963 |
| Centurion | 0 | 1676 |
| Glyphosate | 0 | 2596 |
| Heat | 0 | 2596 |
| Terraxa FX4 | 0 | 2829 |
