I am looking for a way to search through a excel file and find the total amount of gallons that a certain location was using. The excel file would go as follows:
Location: Product: Usage
New York City Diesel 30
Billings Unleaded 42
New York City Diesel 55
Dallas Unleaded 14
(Assuming first column is A1:A5, second is B1:5, and third as C1:C5)
While researching I found my best alternative is using the Index and Match functions to accomplish what I need.
I need to search through this data and find any element that contains new York city and diesel. If them two arguments exist I need to add up the total amount of usage.
Im not looking for special functions rather just using Excel.
If anyone can help it would be greatly appreciated.