Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Feb 17, 2013 8:54 AM

Reply
8 replies

Feb 17, 2013 4:27 PM in response to Dave6882

You have a few too many )'s. You are not creating the condition strings correctly.


You would be better off using the EOMONTH formula to get the last day of the month. It is more robust to use the DATE formula to create dates.


=SUMIFS(Table 1 :: D29:D44,Table 1 :: A29:A44,">="&DATE(2013,2,1),Table 1 :: A29:A44,"<="&EOMONTH(DATE(2013,2,1),0))


or


=SUMIFS(Table 1 :: D29:D44,Table 1 :: A29:A44,">=feb 1, 2013",Table 1 :: A29:A44,"<="&EOMONTH("feb 1, 2013",0))

Sum values from a range of dates

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.