Sum Totals from List with Duplicates

[MarkRCC]

Hi All,

I am trying to calculate fuel cost/emissions from a fleet of vehicles and equipment, and I have data going back to July 2016. I have separated each month, but within each month there are still times when a vehicle has refueled, meaning there are multiple duplicates for each Registration ID (my lookup value).

Is there a method of calculating totals for the Registration ID, with multiple rows of data for each? Like a "if RegID = X, then add Y to TotalZ" sort of thing.

Thanks in advance.

 

[Marcelo Branco]

Take a look at SUMIFS
https://support.office.com/en-us/article/SUMIFS-function-C9E748F5-7EA7-455D-9406-611CEBCE642B

M.

 

[MarkRCC]

That's perfect, thanks a lot! I'll be able to use this in plenty of other spreadsheets, too.