Jagat Pavasia
Active Member
- Joined
- Mar 9, 2015
- Messages
- 359
- Office Version
- 2021
- Platform
- Windows
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..
=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..