****EXCEL QUESTION**** Above is image of two Tables First row= Trailer number Fo
ID: 3799947 • Letter: #
Question
****EXCEL QUESTION****
Above is image of two Tables
First row= Trailer number
Fourth Row= Second row + Third row
=SUM(B1+C1)
Fifth Row= Fourth Row/14 when Trailer number/first row starts with "UPST3*****"
=IF(A1>"upst800000",D1/26,D1/14)
Fifth Row=Fourth Row/26 when Trailer numer/ first row starts with "UPST8*****"
Same IF function as above
Highlighted in purple= Same Trailer number under both Table 1 and Table 2
My question is, is there a formula I can use to add the Fourth row data together from Table 1 and Table 2 and have it divided accordingly by 14 or 26 when the trailer numbers are the same under Table 1 and Table 2
This is what i want the function to do, Since table 1 and table 2 both have "UPST877336" i want excel to add the values from both fourth row together, so 149+682= 831 and then since the trailer number starts with "UPST8****" have it diveded by 26 and display it on the fifth row. so 831/26= 32. So the fifth row would display 32 in both Table 1 and Table 2 for Trailer "UPST877336"
Again I just need a function/formula to input into excel t
UPST877336 UPST84 3501 UPST 345201 146 1346 390 149 94 1440 7 397 55.4 28.4 UPST877336 UP ST839133 UPST 307612 615 1331 582 67 682 125 1456 664 82 26.2 56.0 47.4Explanation / Answer
if you are using the both tables inside a single excel sheet in the shown way.
like the columns of two tables can be A,B,C,D,E,F,G,H,I,J,K
then this formula can be used:
=IF(AND(A1>"UPST800000", A1>"UPST800000"),SUM(D1,J1)/26,SUM(D1,J1)/14)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.