## Sum values from a range of dates

344 Views 8 Replies Latest reply: Feb 17, 2013 7:19 PM by Badunit
Calculating status...
Currently Being Moderated
Feb 17, 2013 8:54 AM

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

• Level 2 (220 points)
Currently Being Moderated
Feb 17, 2013 3:57 PM (in response to Dave6882)

I haven't tried to recreate the entire spreadsheet, so there might be something else going on as well, but I can say for certain that you have too few ( relatvie to the number of )'s. It should be one to one &amp; right now you have 3 to 1. That's definitely triggering an error.

• Level 6 (10,510 points)
Currently Being Moderated
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))

• Level 6 (10,510 points)
Currently Being Moderated
Feb 17, 2013 5:11 PM (in response to Dave6882)

Then maybe the only problem was the condition strings not being created correctly.

• Level 6 (10,510 points)
Currently Being Moderated
Feb 17, 2013 6:02 PM (in response to Dave6882)

Kinda hard to read it but I don't see any quotes in the condition strings. Take another look at the formula I posted.  I'm not 100% sure how it looks when typed into the iOS version of Numbers.

• Level 6 (10,510 points)
Currently Being Moderated
Feb 17, 2013 7:19 PM (in response to Dave6882)

When entering a formula, there is a button labelled "abc" (with the quotes). Use it to enter text as part of a formula.

Your formula does not work because it isn't constructed correctly yet. You'll get it.

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.