Formula for total daily expenses To sum up daily expenses, Fj = SUM (Bj:Ej), where, j is the column number. For instance, total daily expenses for; 14-Sep = F5 = SUM (B5:E5) 15-Sep = F6 = SUM (B6:E6) 16-Sep = F7 = SUM (B7:E7) 17-Sep = F8 = SUM (B8:E8) 18-Sep = F9 = SUM (B9:E9) 19-Sep = F10 = SUM (B10:E10) And the grand total for all daily expenses = F11 = SUM (F5:F10) Weekly totals The formula for weekly totals per class of expense will be given by: Auto/Gas weekly totals = B13 = SUM (B5:B11) Hotels weekly totals = C13 = SUM (C5:C11) Meals weekly totals = D13 = SUM (D5:D11) Weekly totals for other expenses = E13 = SUM (E5:E11) Receipt required Print YES To print YES in column G...
Words: 550
Pages: 1