Calute Cells From 3 different columns

Question

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

peterbartholomew1 · Answer

Tom_Jenkins18235&nbsp;SUMIFS provides an alternative approach= SUMIFS(
      milesData, 
      usageData,   usageHdr, 
      vehicleData, vehicleHdr
  )

oliverscheurich · Answer

Tom_Jenkins18235&nbsp;=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.&nbsp;

Forum Discussion

Calute Cells From 3 different columns

Share

Resources