Calute Cells From 3 different columns

[Tom_Jenkins18235]

I have been working for hours trying to get a formula to calculate mileage totals for three different vehicles. I need to calculate the personal and business miles for each vehicle. the ranges on my current spread sheet are C15 to C105 USE, F15 to F105 MILES and K15 to K105 Vehicle. Any help will be greatly appreciated.

Tom Jenkins

USE	MILES*	VEHICLE
Personal	2.5	Junior
Personal	2.7	Jeepy
Business	2.5	Jeepy
Personal	2.7	Boris
Business	2.9	Junior
Business	2.7	Boris

[#2]

@Tom_Jenkins18235 

=SUMPRODUCT(($K$16:$K$105=$C6)*($C$16:$C$105=D$5)*$F$16:$F$105)

You can try this formula like in the attached file. 

[#3]

@Tom_Jenkins18235 

SUMIFS provides an alternative approach

= SUMIFS(
      milesData, 
      usageData,   usageHdr, 
      vehicleData, vehicleHdr
  )