# Date Condition in SUMIFS Statement

1. ## Date Condition in SUMIFS Statement

I'm attempting to do a SUMIFS statement where I sum the values of the 'J' column, but only if the date in the 'D' column falls on or after a specified date. In the below, the string ?????? should basically be saying "if the date in the D column is on or after 5/30/2011".

=SUMIFS(\$J\$2:\$J\$19,\$D\$2:\$D\$19??????)

I tried doing it like this but (as I expected) it did not work:

=SUMIFS(\$J\$2:\$J\$19,\$D\$2:\$D\$19>=”5/30/2011”)

Thanks!

2. ## Re: Date Condition in SUMIFS Statement

Try:.

=SUMIFS(\$J\$2:\$J\$19,\$D\$2:\$D\$19,">=5/30/2011")

not sure what I was thinking... but try above...

or if one condition

=SUMIF(\$D\$2:\$D\$19,">=5/30/2011",\$J\$2:\$J\$19)

3. ## Re: Date Condition in SUMIFS Statement

It's hard with no workbook, but =SUMIFS(\$J\$2:\$J\$19,\$D\$2:\$D\$19,">=5/30/2011”) is the right syntax

4. ## Re: Date Condition in SUMIFS Statement

Try

=SUMIFS(\$J\$2:\$J\$19,\$D\$2:\$D\$19,">=5/30/2011”)

5. ## Re: Date Condition in SUMIFS Statement

The syntax below did not work. I'm attaching a simplified/fictionalized example workbook. The formula would need to go into B11.

6. ## Re: Date Condition in SUMIFS Statement

Works for me... see attached.

7. ## Re: Date Condition in SUMIFS Statement

Never mind my last post. This string from earlier in the thread worked in the "real" workbook:
=SUMIFS(\$J\$2:\$J\$19,\$D\$2:\$D\$19,">=5/30/2011")

Must've copied it wrong but i got there in the end. Thanks!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1