Function

[Gusher]

Hi

In column A I have series of dates. In column D I have numbers.

I need a function that will return the sum of numbers in column D between the dates Jan 1st and June 30th 2017.

Many Thanks, Mark

 

[steve the fish]

Try:

=SUMIFS(D:D,A:A,">="&DATE(2017,1,1),A:A,"<"&DATE(2017,7,1))

 

[Scott T]

Try, where A2:A7 has your dates and B2:B7 has your numbers

=SUMIFS(B2:B7,A2:A7,">="&DATEVALUE("1/1/2017"),A2:A7,"<="&DATEVALUE("6/30/2017"))

 

[Gusher]

Try, where A2:A7 has your dates and B2:B7 has your numbers

=SUMIFS(B2:B7,A2:A7,">="&DATEVALUE("1/1/2017"),A2:A7,"<="&DATEVALUE("6/30/2017"))

Thanks Scott, I tried this and it returned zero, any ideas?

 

[Gusher]

okay figured it out, problem was the date 6/30/2017 - excel didn't like that but did like 30/6/2017, thanks for your help