compare total ytd , write sum formula

calculate company total

compre quarter comparison of company total (compare q2 with q1 and q3 with q2)

please write the formulas if possible i am very confused on what i should be doing here thank you!

f A B D E F G H ACME Tech Inc. Sales (SMillion) Q3% of YTD Product Line Robot Smart-Sensor Company total Quarter-Comparison of Comp Total* Q1 Q1% of YTD Q2 02% of YTD 03 450 550 700 200 150 220 300 250 250 Formula Formula Formula YTD formula formula formula Fornulas -: YTD: Year to date, the sum from beginning to most recent ** rtr-Comp: compare Q2 with Q1, and Q3 with Q2 if nearer qurter is lower than father quarter, disply "Decrease", if nearer qurter is higer than father quarter, disply "Increase"; - if the two are the same, disply"Same". (Please excuse me: It looks a bit messy with the arrows ad the words "formulas"; but a student in TR class was confused "where we're supposed to write formulas", which forced me to do all the annotations.)