Spreadsheet: 35949d1233688517-summing-multiple-rows-using-logic-sample-week
Sheet: Jan 5 - Jan 11

Day | Date | Amount of Customers |  |  | Amount of bags |  |  | Baggage Fees |  | Daily Totals |  |  |  | Weekly Totals
Ship Name |  | Web sales | Presale | Walkups | Web sales | Presale | Walkups | Heavy | Excess | Customers | [NAME] | Fees |  | Ship Name | Times Served | Total Customers | Total Bags
Monday | 2009-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Carnival Freedom | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Carnival Miracle | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Carnival Splendor | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Celebrity Constellation | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Celebrity Infinity | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Celebrity Mercury | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Celebrity Solstice | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Coral Princess | 2
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Crown Princess | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Discovery Sun | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Emerald Princess | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Eurodam | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Grand Princess | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Independence of the Seas | 1
Tuesday | 2009-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Island Princess | 0
Coral Princess |  |  |  | 33 |  |  | 56 | 25 | 50 | 33 | 56 | 75 |  | Maasdam | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Navigator of the Seas | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Pacific Princess | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Prinsendam | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Royal Princess | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Ruby Princess | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | [NAME] | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Westerdam | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | Zuiderdam | 1
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | TOTAL | 15
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Wednesday | 2009-01-07 00:00:00
Coral Princess |  |  |  | 17 |  |  | 34 | 75 |  | 17 | 34 | 75
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Thursday | 2009-01-08 00:00:00
Navigator of the Seas |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Zuiderdam |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Friday | 2009-01-09 00:00:00
Emerald Princess |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Maasdam |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Saturday | 2009-01-10 00:00:00
Carnival Splendor |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Eurodam |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Independence of the Seas |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Ruby Princess |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Sunday | 2009-01-11 00:00:00
Carnival Freedom |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Celebrity Solstice |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Crown Princess |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Westerdam |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Weekly Totals
 |  | 0 | 0 | 50 | 0 | 0 | 90 | 100 | 50 | 50 | 90 | 150
Weekly Customers | 50
Weekly [NAME] | 90
Weekly Fees | 140