Sum values from a range of dates
I have a table with running dates and totals. So in column A are dates, column B contains amounts. In another table I have months, January through December in column A and I want each months totals in column B. I used the following formula but it just returns a syntax error. =SUMIFS(Table 1 ::D29:D44),Table 1 ::A29:A44),=>"Feb 1, 2013",Table 1 ::A29:A44,=<"Feb 28, 2013")
A29:A44 is the column with the dates
D29:D44 is the column with the amounts if like to sum
So look at Column A and add all of the entries that fall into the date range I specify
iPad, iOS 5.1.1, Numbers v1.7.1