How to use sumifs with DD/MM/YYYY HH:MM:SS when I need to find the month and year

[magpie2000k]

I have a day date time cell in a spread sheet I am trying to reference but want to sum if that date = my cell on another spread sheet

The cell on the other spread sheet is simply Nov-17. So I want it to match wher it is indeed from the relevant month regardless of day of month or time of day.

Thanks

 

[FormR]

Hi, something like this maybe?

Excel 2013/2016
	A	B	C	D	E
1	Date Time	Sum Values		01-Nov-2017	14
2	01/11/2017 10:15	2
3	03/11/2017 18:15	2
4	05/11/2017 23:15	8
5	05/12/2017 23:15	7
6	05/11/2017 23:15	2
7	05/12/2018 23:15	10
Sheet1

Cell Formulas
Range	Formula
E1	=SUMIFS(B:B,A:A,">="&D1,A:A,"<"&EOMONTH(D1,0)+1)

 

[magpie2000k]

Thanks
The exact formula is =SUMIFS([QCF.csv]QCF!$I:$I,[QCF.csv]QCF!$AF:$AF,D$8,[QCF.csv]QCF!$K:$K,"Confirmed")

Should have posted first in D$8 I have Nov-17
In AF Column I have 01/11/2017 hh:mm:ss

 

[FormR]

You'll need to add back the file references - but it would look something like..

=SUMIFS($I:$I,$AF:$AF,">="&D$8,$AF:$AF,"<"&EOMONTH(D$8,0),$K:$K,"Confirmed")

 

[magpie2000k]

works perfect.

Thanks