I have a question on how to find the maximum total freight weight for the truck numbers and colors specified below using excel spreadsheet?
FYI just by looking at the numbers and color of the trucks, it is easy to identify that the green trucks have more freight weight of 300+300= 600Kg. This number is more than the sum of the freight weight compared to the other colored trucks. I have a large excel data with similar concept and would like to find an easier way of finding the maximum total weight of a specific color truck.
Please help
Truck Number Truck Color Freight Weight (Kg)
1 Yellow 100
2 Yellow 300
3 Blue 200
4 Orange 100
5 Red 400
6 Red 100
7 White 150
8 Green 300
9 Green 300
10 Brown 100