Making a dumb spreadsheet smart
January 14, 2011 1:55 PM Subscribe
I'm having trouble solving a problem in Google Spreadsheet.
Check out this screenshot.
posted by downing street memo to computers & internet (3 answers total)
Basically, this is a calorie counter. In column A, I put the date, in column B, a list of all the things I ate, in column C, their caloric values.
Column D and E are formulas based off C. Column D adds up all the calories for the day, while column E takes the total from column D and calculates caloric deficit.
As of now, I manually enter in formulas into D and E to get the daily sum and deficit. I'd prefer this to be automatic. How can I make the spreadsheet understand when I've entered a new date, and begin calculating the sum from the first row of the new date?