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