Sumif with date range

[LynnWilson]

Hi

I am new to this forum and really struggling with the dates in the sumif function.

Column A has a range of dates from April to August
Column H has a a range of values associated with membership

I need to sum the income from membership for a range of dates
ie sum column H for dates between 1st and 30th April.

i have tried both sumif and sumifs statements and seem to be having problems with the date format.

I have taken advice and been told to use...
=sumifs(H1:H1000,A1:A1000, ">=&E1,A1:A1000,”<=”&E2
where E1 is a cell containing 01/04/2017
and E2 is a cell containing 30/04/2017

This doesn't work and i do not understand the logic of placing the " in that fashion.

Many thanks for any assistance

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Pete_UK]

It may just be a typo on this forum, but the formula you quoted has a set of quotes missing, as well as a bracket at the end - try it like this:

=sumifs(H1:H1000,A1:A1000, ">="&E1,A1:A1000,”<=”&E2)

Hope this helps.

Pete