Forum Discussion
Tom_Jenkins18235
Jun 07, 2022Copper Contributor
Calute Cells From 3 different columns
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 ...
PeterBartholomew1
Jun 07, 2022Silver Contributor
SUMIFS provides an alternative approach
= SUMIFS(
milesData,
usageData, usageHdr,
vehicleData, vehicleHdr
)