8 Replies Latest reply: Feb 17, 2013 7:19 PM by Badunit
Dave6882 Level 1 Level 1 (0 points)

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