Why can't spreadsheets work like brains?
April 6, 2012 3:15 PM Subscribe
Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right?
posted by frecklefaerie to computers & internet (7 answers total) 4 users marked this as a favorite
I have a google spreadsheet. Column A is dates, column B is numbers. How do I write a function that will show a sum in a cell in column C by month? Basically I want a function that says, "If column A is between this and that date. then add the number from column B."
The easy work around would be to separate out the dates from "4/6/2012" and have a separate column for each then use the IF function on the month name column. Is there a more elegant solution?