HELP WITH SUMIFS

[Jagat Pavasia]

I HAVE FORMULA BELOW :

=SUMIFS(E6:E8000,L6:L8000,"O",N6:N8000,">="&DATEVALUE("1/11/2020"),N6:N8000,"<="&DATEVALUE("30/11/2020"))

I WANT TOTAL OF E6 : E8000 WITH SELECTED DATE RANGE, BUT MY N6:N8000 HAVE BOTH DATE AND TIME,
FOR EXAMPLE: " 7/11/20, 11:54 AM".

SO THE ANSWER IS DID NOT SHOWING, IF MY N6:N8000 HAVE ONLY DATE THEN IT IS WORKING.

BUT I WANT DATE WITH TIME, PLEASE GIVE ME FORMULA..

 

[arthurbr]

Is your date /time data real or text looking like date/time. (left aligned in the latter case)
In the latter case you can extract the date using Text to columns or some other method
When N only contains date after extraction try

=SUMPRODUCT(--(L6:L8000)="O",--(month(N6:N8000)=11)*E6:E8000)

Also note that writing in capital letters is the equivalent of shouting, and as we are all friends here...

 

[Jagat Pavasia]

This will only work if your date time data is real or text looking like date/time.
In the latter case you can extract the date using Text to columns or some other method
When N only contains date after extraction try

=SUMPRODUCT(--(L6:L8000)="O",--(month(N6:N8000)=11)*E6:E8000)

Also note that writing in capital letters is the equivalent of shouting, and as we are all friends here...

it did not work ...

I want total of E6 to E8000, but condition is only those who have "O" in L6:L8000 and N6:N8000 within date and time range of 01/11/2020 to 30/11/2020. (N6:N8000 have date and time for example : "7/11/20, 1:46 PM".

 

[arthurbr]

Did you remove the time as suggested ?