Modifying Formula

[aligahk06]

Dear All,
Please modify the highlighted bold formula that gives the result in such a way.

=SUM(COUNTIFS(RM!$F:$F,$D25,RM!$H:$H,{"COMP","CLOSE","WCLOSE"},RM!$I:$I,">="&DATE(2018,12,1),RM!$I:$I,"<="&EOMONTH(DATE(2018,12,1),0)))

1. RM!$I:$I,">="&DATE(2018,12,1) It will calculate based on 1dec 2018 time 00:59:59.000 am (hh:mm:ss.mmm)
2.RM!$I:$I,"<="&EOMONTH(DATE(2018,12,1) It will calculate based on 31dec 2018 time 23:59:59.000 pm

Please help me to get the result based on date and time

Thanks

Regards,
aligahk06

 

[FormR]

Hi, you could try like this:

=SUM(COUNTIFS(RM!$F:$F,$D25,RM!$H:$H,{"COMP","CLOSE","WCLOSE"},RM!$I:$I,">="&DATE(2018,12,1)+"00:59:59",RM!$I:$I,"<"&EOMONTH(DATE(2018,12,1)+1,0)))

 

[aligahk06]

Hi, you could try like this:

=SUM(COUNTIFS(RM!$F:$F,$D25,RM!$H:$H,{"COMP","CLOSE","WCLOSE"},RM!$I:$I,">="&DATE(2018,12,1)+"00:59:59",RM!$I:$I,"<"&EOMONTH(DATE(2018,12,1)+1,0)))

Sir, It won't give the result.
The excel cell consists the value [TABLE="width: 152"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]12/4/2018 14:09[/TD]
[/TR]
[TR]
[TD="align: right"]12/31/2018 4:50[/TD]
[/TR]
[TR]
[TD="align: right"]12/31/2018 15:09[/TD]
[/TR]
[TR]
[TD="align: right"]12/3/2018 16:07[/TD]
[/TR]
[TR]
[TD="align: right"]12/6/2018 15:15[/TD]
[/TR]
[TR]
[TD="align: right"]12/31/2018 14:09[/TD]
[/TR]
[TR]
[TD="align: right"]12/4/2018 16:52[/TD]
[/TR]
[TR]
[TD="align: right"]12/5/2018 15:56[/TD]
[/TR]
[TR]
[TD="align: right"]12/10/2018 16:32[/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

It won't give the result.

Hi, that doesn't give us much to go on to help you debug.

The excel cell consists the value ..

Perhaps you can re-post this example data but also include examples of the values in the other columns. Also, let us know what the suggested formula returns for your example data and what result you actually expected.