# SUMIFS(Month) help

1. ## SUMIFS(Month) help

This should be working but it is not for some reason, and I don't see it.
Any help is appreciated.

``Please Login or Register  to view this content.``
Table1 has my info
E4 is the start of month, F4 is the last day of the month
``Please Login or Register  to view this content.``

2. ## Re: SUMIFS(Month) help

Try this:

=SUMIFS(Table1[Amount],Table1[Date],">="&E4,Table1[Date],"<="&F4)

3. ## Re: SUMIFS(Month) help

Thanks AliGW, however that didn't solve it.

4. ## Re: SUMIFS(Month) help

Works for me on your sample:

Excel 2016 (Windows) 32 bit
E
F
G
3
Month Start Month End Sum
4
01/06/2020
30/06/2020
\$ 135.43
5
01/07/2020
31/07/2020
\$ 419.28
6
01/08/2020
31/08/2020
\$ 388.76
7
01/09/2020
30/09/2020
\$ 342.41
8
01/10/2020
31/10/2020
\$ 294.90
9
01/11/2020
30/11/2020
\$ 285.34
10
01/12/2020
31/12/2020
\$ 118.94
11
01/01/2021
31/01/2021
\$ -
 Sheet: Sheet1

Excel 2016 (Windows) 32 bit
G
4
=SUMIFS(Table13[Amount],Table13[Date],">="&E4,Table13[Date],"<="&F4)
 Sheet: Sheet1

5. ## Re: SUMIFS(Month) help

Interesting... it is Table13 for some reason, not Table1. that's just odd.

Working now, Thanks!

6. ## Re: SUMIFS(Month) help

Yes - that's the name that Excel gave your table when you created it - look at the Name Manager on the Formulas ribbon.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

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