Forum Discussion
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 ...
=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.