How to prepare a 7 AM to 7 AM Report

Dhinakaran

New Member
Joined
Mar 30, 2016
Messages
23
Office Version
  1. 2016
Platform
  1. Windows
Hi All,

Need your suggestion on preparing a report for a 24 hours period i.e, from 6 AM to 6 AM or 7 AM to 7 AM.

For instance, lets assume that i have complete data for February-2022 period and the transaction have been made through the day.
- I need to identify a day sales value (i.e, from 1-Feb 7 AM to 2-Feb 7 AM).
- When I do this through a pivot table, the total sales value populated is combined for the complete 24 hours period on both these days (i.e, 1-Feb and 2-Feb).
- As a result I need to manually prepare the required data.

Do find the below sample for reference.
Created Date
Sales Value​
03-02-2022 23:38:00339400
03-02-2022 23:35:08339500
03-02-2022 23:29:17339600
03-02-2022 23:27:23339700
03-02-2022 23:22:55339800
03-02-2022 23:22:00339900
03-02-2022 23:04:43340000
03-02-2022 21:50:41340100
03-02-2022 21:41:33340200
03-02-2022 21:35:19340300
03-02-2022 21:35:00340400
03-02-2022 21:32:13340500
03-02-2022 21:26:47340600
03-02-2022 21:26:02340700
03-02-2022 21:14:43340800
03-02-2022 21:13:36340900
03-02-2022 21:05:23341000
03-02-2022 21:00:48341100
03-02-2022 20:55:50341200
03-02-2022 20:54:16341300
03-02-2022 20:38:08341400
03-02-2022 20:09:15341500
03-02-2022 20:06:35341600
03-02-2022 20:03:33341700
03-02-2022 20:02:21341800
03-02-2022 20:01:49341900
03-02-2022 19:49:36342000
03-02-2022 19:48:36342100
03-02-2022 19:46:31342200
03-02-2022 19:45:42342300
03-02-2022 19:43:13342400
03-02-2022 19:31:14342500
03-02-2022 19:28:08342600
03-02-2022 19:27:00342700
03-02-2022 19:25:26342800
03-02-2022 19:20:17342900
03-02-2022 19:20:07343000
03-02-2022 19:11:44343100
03-02-2022 19:02:57343200
03-02-2022 18:46:12343300
03-02-2022 18:32:44343400
03-02-2022 18:19:56343500
03-02-2022 18:15:30343600
03-02-2022 18:14:38343700
03-02-2022 18:10:12343800
03-02-2022 18:07:25343900
03-02-2022 18:05:18344000
03-02-2022 17:47:36344100
03-02-2022 17:43:42344200
03-02-2022 16:59:00344300
03-02-2022 16:58:41344400
03-02-2022 16:56:39344500
03-02-2022 16:54:58344600
03-02-2022 16:49:29344700
03-02-2022 14:37:54344800
03-02-2022 14:31:52344900
03-02-2022 14:20:07345000
03-02-2022 14:18:28345100
03-02-2022 13:58:11345200
03-02-2022 13:56:54345300
03-02-2022 13:17:12345400
03-02-2022 13:15:46345500
03-02-2022 13:05:47345600
03-02-2022 13:03:31345700
03-02-2022 12:58:58345800
03-02-2022 12:56:07345900
03-02-2022 12:50:16346000
03-02-2022 12:39:35346100
03-02-2022 12:32:27346200
03-02-2022 12:24:04346300
03-02-2022 12:16:00346400
03-02-2022 12:12:07346500
03-02-2022 12:05:05346600
03-02-2022 11:54:49346700
03-02-2022 11:46:29346800
03-02-2022 11:16:25346900
03-02-2022 11:07:18347000
03-02-2022 11:00:48347100
03-02-2022 10:49:26347200
03-02-2022 10:41:42347300
03-02-2022 10:35:50347400
03-02-2022 10:34:07347500
03-02-2022 10:31:45347600
03-02-2022 10:14:01347700
03-02-2022 10:11:38347800
03-02-2022 10:05:15347900
03-02-2022 10:02:26348000
03-02-2022 09:59:46348100
03-02-2022 09:58:12348200
03-02-2022 00:05:11348300
03-02-2022 00:01:13348400
02-02-2022 23:45:21348500
02-02-2022 23:45:17348600
02-02-2022 23:26:02348700
02-02-2022 23:21:26348800
02-02-2022 23:10:10348900
02-02-2022 22:50:37349000
02-02-2022 22:47:28349100
02-02-2022 22:46:41349200
02-02-2022 22:43:58349300
02-02-2022 22:40:10349400
02-02-2022 22:25:33349500
02-02-2022 22:23:51349600
02-02-2022 22:23:46349700
02-02-2022 22:21:09349800
02-02-2022 22:20:57349900
02-02-2022 22:19:03350000
02-02-2022 22:18:30350100
02-02-2022 22:17:15350200
02-02-2022 22:14:55350300
02-02-2022 21:36:26350400
02-02-2022 21:34:42350500
02-02-2022 21:33:11350600
02-02-2022 21:25:38350700
02-02-2022 21:24:50350800
02-02-2022 21:18:53350900
02-02-2022 20:42:40351000
02-02-2022 20:40:44351100
02-02-2022 20:36:22351200
02-02-2022 20:35:59351300
02-02-2022 20:33:30351400
02-02-2022 20:33:26351500
02-02-2022 20:30:14351600
02-02-2022 20:25:00351700
02-02-2022 20:01:39351800
02-02-2022 19:56:14351900
02-02-2022 19:54:59352000
02-02-2022 19:53:49352100
02-02-2022 19:53:23352200
02-02-2022 19:52:26352300
02-02-2022 19:51:30352400
02-02-2022 19:45:33352500
02-02-2022 19:43:40352600
02-02-2022 19:41:56352700
02-02-2022 19:38:29352800
02-02-2022 19:38:25352900
02-02-2022 19:31:45353000
02-02-2022 19:30:34353100
02-02-2022 19:27:15353200
02-02-2022 19:25:18353300
02-02-2022 19:12:48353400
02-02-2022 19:11:39353500
02-02-2022 19:10:32353600
02-02-2022 19:05:51353700
02-02-2022 19:03:37353800
02-02-2022 19:01:18353900
02-02-2022 19:00:28354000
02-02-2022 19:00:02354100
02-02-2022 18:57:36354200
02-02-2022 18:38:32354300
02-02-2022 18:36:30354400
02-02-2022 18:32:05354500
02-02-2022 18:31:10354600
02-02-2022 18:29:47354700
02-02-2022 18:21:00354800
02-02-2022 18:20:45354900
02-02-2022 18:17:59355000
02-02-2022 18:17:44355100
02-02-2022 18:15:15355200
02-02-2022 18:07:13355300
02-02-2022 17:58:48355400
02-02-2022 17:58:08355500
02-02-2022 17:32:17355600
02-02-2022 17:29:28355700
02-02-2022 17:24:27355800
02-02-2022 17:20:22355900
02-02-2022 17:15:53356000
02-02-2022 17:07:26356100
02-02-2022 17:01:17356200
02-02-2022 16:54:24356300
02-02-2022 16:41:36356400
02-02-2022 15:54:55356500
02-02-2022 15:53:00356600
02-02-2022 15:51:50356700
02-02-2022 15:41:33356800
02-02-2022 15:38:49356900
02-02-2022 15:35:48357000
02-02-2022 15:33:36357100
02-02-2022 15:21:53357200
02-02-2022 15:18:39357300
02-02-2022 15:12:54357400
02-02-2022 14:25:26357500
02-02-2022 14:24:15357600
02-02-2022 13:39:42357700
02-02-2022 12:59:36357800
02-02-2022 12:58:17357900
02-02-2022 12:57:51358000
02-02-2022 12:56:24358100
02-02-2022 12:51:25358200
02-02-2022 12:22:03358300
02-02-2022 12:20:56358400
02-02-2022 12:19:16358500
02-02-2022 11:55:48358600
02-02-2022 11:24:24358700
02-02-2022 11:23:25358800
02-02-2022 11:04:29358900
02-02-2022 11:03:02359000
02-02-2022 10:59:19359100
02-02-2022 10:52:03359200
02-02-2022 10:45:20359300
02-02-2022 10:42:19359400
02-02-2022 10:27:16359500
02-02-2022 10:00:35359600
02-02-2022 09:57:12359700
02-02-2022 09:38:29359800
02-02-2022 09:30:47359900
02-02-2022 08:55:09360000
02-02-2022 08:45:08360100
02-02-2022 08:28:25360200
02-02-2022 01:22:47360300
02-02-2022 01:15:08360400
02-02-2022 01:13:55360500
02-02-2022 01:13:43360600
02-02-2022 01:13:35360700
02-02-2022 01:11:54360800
02-02-2022 01:08:25360900
02-02-2022 01:06:02361000
02-02-2022 01:03:30361100
02-02-2022 01:03:16361200
02-02-2022 00:47:57361300
02-02-2022 00:24:28361400
02-02-2022 00:19:11361500
01-02-2022 23:59:09361600
01-02-2022 23:53:38361700
01-02-2022 23:49:49361800
01-02-2022 23:48:32361900
01-02-2022 23:48:12362000
01-02-2022 23:44:23362100
01-02-2022 23:41:01362200
01-02-2022 23:39:24362300
01-02-2022 23:34:25362400
01-02-2022 23:33:12362500
01-02-2022 23:32:30362600
01-02-2022 23:19:23362700
01-02-2022 23:16:46362800
01-02-2022 22:32:16362900
01-02-2022 22:27:48363000
01-02-2022 22:17:31363100
01-02-2022 22:12:43363200
01-02-2022 22:12:33363300
01-02-2022 22:11:46363400
01-02-2022 21:51:10363500
01-02-2022 21:50:42363600
01-02-2022 21:50:19363700
01-02-2022 21:48:10363800
01-02-2022 21:47:13363900
01-02-2022 21:46:37364000
01-02-2022 21:45:03364100
01-02-2022 21:44:56364200
01-02-2022 21:41:56364300
01-02-2022 21:40:07364400
01-02-2022 21:38:34364500
01-02-2022 21:35:52364600
01-02-2022 21:28:10364700
01-02-2022 21:10:31364800
01-02-2022 21:05:37364900
01-02-2022 21:04:48365000
01-02-2022 21:02:07365100
01-02-2022 21:01:37365200
01-02-2022 21:00:01365300
01-02-2022 20:59:27365400
01-02-2022 20:53:11365500
01-02-2022 20:00:57365600
01-02-2022 19:57:41365700
01-02-2022 19:54:56365800
01-02-2022 19:52:26365900
01-02-2022 19:51:21366000
01-02-2022 19:49:36366100
01-02-2022 19:48:23366200
01-02-2022 19:47:09366300
01-02-2022 19:46:50366400
01-02-2022 19:45:50366500
01-02-2022 19:45:09366600
01-02-2022 19:41:29366700
01-02-2022 19:29:07366800
01-02-2022 19:28:16366900
01-02-2022 19:17:44367000
01-02-2022 19:16:16367100
01-02-2022 19:11:48367200
01-02-2022 19:07:34367300
01-02-2022 19:03:04367400
01-02-2022 18:57:08367500
01-02-2022 18:23:22367600
01-02-2022 18:17:51367700
01-02-2022 17:19:59367800
01-02-2022 17:18:18367900
01-02-2022 17:03:29368000
01-02-2022 16:55:43368100
01-02-2022 16:47:11368200
01-02-2022 16:45:29368300
01-02-2022 16:41:25368400
01-02-2022 16:27:43368500
01-02-2022 16:12:13368600
01-02-2022 16:03:13368700
01-02-2022 15:40:15368800
01-02-2022 15:24:11368900
01-02-2022 15:17:49369000
01-02-2022 14:02:40369100
01-02-2022 13:58:22369200
01-02-2022 12:57:12369300
01-02-2022 12:33:40369400
01-02-2022 12:28:49369500
01-02-2022 12:27:07369600
01-02-2022 10:55:29369700
01-02-2022 10:35:28369800
01-02-2022 10:30:20369900
01-02-2022 10:25:18370000
01-02-2022 10:19:42370100
01-02-2022 10:14:59370200
01-02-2022 10:07:09370300
01-02-2022 10:02:17370400
01-02-2022 09:49:24370500
01-02-2022 08:38:32370600
01-02-2022 08:34:07370700
01-02-2022 08:30:39370800
01-02-2022 08:26:12370900
01-02-2022 08:21:32371000
01-02-2022 08:15:16371100
01-02-2022 08:09:57371200
01-02-2022 08:03:37371300
01-02-2022 07:58:02371400
01-02-2022 03:30:13371500
01-02-2022 03:25:07371600
01-02-2022 03:20:08371700
01-02-2022 03:15:37371800
01-02-2022 03:08:33371900
01-02-2022 01:32:36372000
01-02-2022 01:20:32372100
01-02-2022 01:18:06372200
01-02-2022 01:11:45372300
01-02-2022 01:11:33372400
01-02-2022 01:07:47372500
01-02-2022 01:04:11372600
01-02-2022 01:03:12372700
01-02-2022 00:56:33372800
01-02-2022 00:51:52372900
01-02-2022 00:50:08373000
01-02-2022 00:43:57373100
01-02-2022 00:43:00373200
01-02-2022 00:34:32373300
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

gordsky

Well-known Member
Joined
Jun 2, 2016
Messages
518
Office Version
  1. 2016
Platform
  1. Windows
I take it you have used the date filter option within the pivot table
 

queuesmef

Board Regular
Joined
Dec 19, 2016
Messages
72
Try using Advanced Data Filtering, where you can copy info
Rich (BB code):

		
		
	


	
1646842445559.png
1646842464229.png
to another location (Data/ Filter /Advanced (with 'Copy to another location'). Copy the headings (must match EXACTLY the same). This will give you a copy of your data filtered.
OR you could try to use SUMIFS formula? Sort of the same concept....
Excel Formula:
=SUMIFS(B13:B353,A13:A353,">="&G19,A13:A353,"<="&G18)
Note: my data range is A13:B353. I used 2 Created Date - so I could put in the Begining & Ending points of your range requested
 

Sufiyan97

Well-known Member
Joined
Apr 12, 2019
Messages
707
Office Version
  1. 2013
Platform
  1. Windows
Try
 
Last edited:

Sufiyan97

Well-known Member
Joined
Apr 12, 2019
Messages
707
Office Version
  1. 2013
Platform
  1. Windows
Try

Book1
ABCDE
1Created DateSales ValueStartEnd
23/2/2022 23:383394001/1/2022 7:001/2/2022 7:00
33/2/2022 23:35339500
43/2/2022 23:29339600Total7075600
53/2/2022 23:27339700
63/2/2022 23:22339800
73/2/2022 23:22339900
83/2/2022 23:04340000
93/2/2022 21:50340100
103/2/2022 21:41340200
113/2/2022 21:35340300
123/2/2022 21:35340400
133/2/2022 21:32340500
143/2/2022 21:26340600
153/2/2022 21:26340700
163/2/2022 21:14340800
173/2/2022 21:13340900
183/2/2022 21:05341000
193/2/2022 21:00341100
203/2/2022 20:55341200
213/2/2022 20:54341300
223/2/2022 20:38341400
233/2/2022 20:09341500
243/2/2022 20:06341600
253/2/2022 20:03341700
263/2/2022 20:02341800
273/2/2022 20:01341900
283/2/2022 19:49342000
293/2/2022 19:48342100
303/2/2022 19:46342200
313/2/2022 19:45342300
323/2/2022 19:43342400
333/2/2022 19:31342500
343/2/2022 19:28342600
353/2/2022 19:27342700
363/2/2022 19:25342800
373/2/2022 19:20342900
383/2/2022 19:20343000
393/2/2022 19:11343100
403/2/2022 19:02343200
413/2/2022 18:46343300
423/2/2022 18:32343400
433/2/2022 18:19343500
443/2/2022 18:15343600
453/2/2022 18:14343700
463/2/2022 18:10343800
473/2/2022 18:07343900
483/2/2022 18:05344000
493/2/2022 17:47344100
503/2/2022 17:43344200
513/2/2022 16:59344300
523/2/2022 16:58344400
533/2/2022 16:56344500
543/2/2022 16:54344600
553/2/2022 16:49344700
563/2/2022 14:37344800
573/2/2022 14:31344900
583/2/2022 14:20345000
593/2/2022 14:18345100
603/2/2022 13:58345200
613/2/2022 13:56345300
623/2/2022 13:17345400
633/2/2022 13:15345500
643/2/2022 13:05345600
653/2/2022 13:03345700
663/2/2022 12:58345800
673/2/2022 12:56345900
683/2/2022 12:50346000
693/2/2022 12:39346100
703/2/2022 12:32346200
713/2/2022 12:24346300
723/2/2022 12:16346400
733/2/2022 12:12346500
743/2/2022 12:05346600
753/2/2022 11:54346700
763/2/2022 11:46346800
773/2/2022 11:16346900
783/2/2022 11:07347000
793/2/2022 11:00347100
803/2/2022 10:49347200
813/2/2022 10:41347300
823/2/2022 10:35347400
833/2/2022 10:34347500
843/2/2022 10:31347600
853/2/2022 10:14347700
863/2/2022 10:11347800
873/2/2022 10:05347900
883/2/2022 10:02348000
893/2/2022 9:59348100
903/2/2022 9:58348200
913/2/2022 0:05348300
923/2/2022 0:01348400
931/3/2022 23:45348500
941/3/2022 23:45348600
951/3/2022 23:26348700
961/3/2022 23:21348800
971/3/2022 23:10348900
981/3/2022 22:50349000
991/3/2022 22:47349100
1001/3/2022 22:46349200
1011/3/2022 22:43349300
1021/3/2022 22:40349400
1031/3/2022 22:25349500
1041/3/2022 22:23349600
1051/3/2022 22:23349700
1061/3/2022 22:21349800
1071/3/2022 22:20349900
1081/3/2022 22:19350000
1091/3/2022 22:18350100
1101/3/2022 22:17350200
1111/3/2022 22:14350300
1121/3/2022 21:36350400
1131/3/2022 21:34350500
1141/3/2022 21:33350600
1151/3/2022 21:25350700
1161/3/2022 21:24350800
1171/3/2022 21:18350900
1181/3/2022 20:42351000
1191/3/2022 20:40351100
1201/3/2022 20:36351200
1211/3/2022 20:35351300
1221/3/2022 20:33351400
1231/3/2022 20:33351500
1241/3/2022 20:30351600
1251/3/2022 20:25351700
1261/3/2022 20:01351800
1271/3/2022 19:56351900
1281/3/2022 19:54352000
1291/3/2022 19:53352100
1301/3/2022 19:53352200
1311/3/2022 19:52352300
1321/3/2022 19:51352400
1331/3/2022 19:45352500
1341/3/2022 19:43352600
1351/3/2022 19:41352700
1361/3/2022 19:38352800
1371/3/2022 19:38352900
1381/3/2022 19:31353000
1391/3/2022 19:30353100
1401/3/2022 19:27353200
1411/3/2022 19:25353300
1421/3/2022 19:12353400
1431/3/2022 19:11353500
1441/3/2022 19:10353600
1451/3/2022 19:05353700
1461/3/2022 19:03353800
1471/3/2022 19:01353900
1481/3/2022 19:00354000
1491/3/2022 19:00354100
1501/3/2022 18:57354200
1511/3/2022 18:38354300
1521/3/2022 18:36354400
1531/3/2022 18:32354500
1541/3/2022 18:31354600
1551/3/2022 18:29354700
1561/3/2022 18:21354800
1571/3/2022 18:20354900
1581/3/2022 18:17355000
1591/3/2022 18:17355100
1601/3/2022 18:15355200
1611/3/2022 18:07355300
1621/3/2022 17:58355400
1631/3/2022 17:58355500
1641/3/2022 17:32355600
1651/3/2022 17:29355700
1661/3/2022 17:24355800
1671/3/2022 17:20355900
1681/3/2022 17:15356000
1691/3/2022 17:07356100
1701/3/2022 17:01356200
1711/3/2022 16:54356300
1721/3/2022 16:41356400
1731/3/2022 15:54356500
1741/3/2022 15:53356600
1751/3/2022 15:51356700
1761/3/2022 15:41356800
1771/3/2022 15:38356900
1781/3/2022 15:35357000
1791/3/2022 15:33357100
1801/3/2022 15:21357200
1811/3/2022 15:18357300
1821/3/2022 15:12357400
1831/3/2022 14:25357500
1841/3/2022 14:24357600
1851/3/2022 13:39357700
1861/3/2022 12:59357800
1871/3/2022 12:58357900
1881/3/2022 12:57358000
1891/3/2022 12:56358100
1901/3/2022 12:51358200
1911/3/2022 12:22358300
1921/3/2022 12:20358400
1931/3/2022 12:19358500
1941/3/2022 11:55358600
1951/3/2022 11:24358700
1961/3/2022 11:23358800
1971/3/2022 11:04358900
1981/3/2022 11:03359000
1991/3/2022 10:59359100
2001/3/2022 10:52359200
2011/3/2022 10:45359300
2021/3/2022 10:42359400
2031/3/2022 10:27359500
2041/3/2022 10:00359600
2051/3/2022 9:57359700
2061/3/2022 9:38359800
2071/3/2022 9:30359900
2081/3/2022 8:55360000
2091/3/2022 8:45360100
2101/3/2022 8:28360200
2111/3/2022 1:22360300
2121/3/2022 1:15360400
2131/3/2022 1:13360500
2141/3/2022 1:13360600
2151/3/2022 1:13360700
2161/3/2022 1:11360800
2171/3/2022 1:08360900
2181/3/2022 1:06361000
2191/3/2022 1:03361100
2201/3/2022 1:03361200
2211/3/2022 0:47361300
2221/3/2022 0:24361400
2231/3/2022 0:19361500
2241/2/2022 23:59361600
2251/2/2022 23:53361700
2261/2/2022 23:49361800
2271/2/2022 23:48361900
2281/2/2022 23:48362000
2291/2/2022 23:44362100
2301/2/2022 23:41362200
2311/2/2022 23:39362300
2321/2/2022 23:34362400
2331/2/2022 23:33362500
2341/2/2022 23:32362600
2351/2/2022 23:19362700
2361/2/2022 23:16362800
2371/2/2022 22:32362900
2381/2/2022 22:27363000
2391/2/2022 22:17363100
2401/2/2022 22:12363200
2411/2/2022 22:12363300
2421/2/2022 22:11363400
2431/2/2022 21:51363500
2441/2/2022 21:50363600
2451/2/2022 21:50363700
2461/2/2022 21:48363800
2471/2/2022 21:47363900
2481/2/2022 21:46364000
2491/2/2022 21:45364100
2501/2/2022 21:44364200
2511/2/2022 21:41364300
2521/2/2022 21:40364400
2531/2/2022 21:38364500
2541/2/2022 21:35364600
2551/2/2022 21:28364700
2561/2/2022 21:10364800
2571/2/2022 21:05364900
2581/2/2022 21:04365000
2591/2/2022 21:02365100
2601/2/2022 21:01365200
2611/2/2022 21:00365300
2621/2/2022 20:59365400
2631/2/2022 20:53365500
2641/2/2022 20:00365600
2651/2/2022 19:57365700
2661/2/2022 19:54365800
2671/2/2022 19:52365900
2681/2/2022 19:51366000
2691/2/2022 19:49366100
2701/2/2022 19:48366200
2711/2/2022 19:47366300
2721/2/2022 19:46366400
2731/2/2022 19:45366500
2741/2/2022 19:45366600
2751/2/2022 19:41366700
2761/2/2022 19:29366800
2771/2/2022 19:28366900
2781/2/2022 19:17367000
2791/2/2022 19:16367100
2801/2/2022 19:11367200
2811/2/2022 19:07367300
2821/2/2022 19:03367400
2831/2/2022 18:57367500
2841/2/2022 18:23367600
2851/2/2022 18:17367700
2861/2/2022 17:19367800
2871/2/2022 17:18367900
2881/2/2022 17:03368000
2891/2/2022 16:55368100
2901/2/2022 16:47368200
2911/2/2022 16:45368300
2921/2/2022 16:41368400
2931/2/2022 16:27368500
2941/2/2022 16:12368600
2951/2/2022 16:03368700
2961/2/2022 15:40368800
2971/2/2022 15:24368900
2981/2/2022 15:17369000
2991/2/2022 14:02369100
3001/2/2022 13:58369200
3011/2/2022 12:57369300
3021/2/2022 12:33369400
3031/2/2022 12:28369500
3041/2/2022 12:27369600
3051/2/2022 10:55369700
3061/2/2022 10:35369800
3071/2/2022 10:30369900
3081/2/2022 10:25370000
3091/2/2022 10:19370100
3101/2/2022 10:14370200
3111/2/2022 10:07370300
3121/2/2022 10:02370400
3131/2/2022 9:49370500
3141/2/2022 8:38370600
3151/2/2022 8:34370700
3161/2/2022 8:30370800
3171/2/2022 8:26370900
3181/2/2022 8:21371000
3191/2/2022 8:15371100
3201/2/2022 8:09371200
3211/2/2022 8:03371300
3221/2/2022 7:58371400
3231/2/2022 3:30371500
3241/2/2022 3:25371600
3251/2/2022 3:20371700
3261/2/2022 3:15371800
3271/2/2022 3:08371900
3281/2/2022 1:32372000
3291/2/2022 1:20372100
3301/2/2022 1:18372200
3311/2/2022 1:11372300
3321/2/2022 1:11372400
3331/2/2022 1:07372500
3341/2/2022 1:04372600
3351/2/2022 1:03372700
3361/2/2022 0:56372800
3371/2/2022 0:51372900
3381/2/2022 0:50373000
3391/2/2022 0:43373100
3401/2/2022 0:43373200
3411/2/2022 0:34373300
Sheet1
Cell Formulas
RangeFormula
E4E4=SUMIFS(B:B,A:A,">="&D2,A:A,"<="&E2)
Named Ranges
NameRefers ToCells
_FilterDatabase=Sheet1!$A$1:$B$341E4
 
Solution

Dhinakaran

New Member
Joined
Mar 30, 2016
Messages
23
Office Version
  1. 2016
Platform
  1. Windows
T
Try

Book1
ABCDE
1Created DateSales ValueStartEnd
23/2/2022 23:383394001/1/2022 7:001/2/2022 7:00
33/2/2022 23:35339500
43/2/2022 23:29339600Total7075600
53/2/2022 23:27339700
63/2/2022 23:22339800
73/2/2022 23:22339900
83/2/2022 23:04340000
93/2/2022 21:50340100
103/2/2022 21:41340200
113/2/2022 21:35340300
123/2/2022 21:35340400
133/2/2022 21:32340500
143/2/2022 21:26340600
153/2/2022 21:26340700
163/2/2022 21:14340800
173/2/2022 21:13340900
183/2/2022 21:05341000
193/2/2022 21:00341100
203/2/2022 20:55341200
213/2/2022 20:54341300
223/2/2022 20:38341400
233/2/2022 20:09341500
243/2/2022 20:06341600
253/2/2022 20:03341700
263/2/2022 20:02341800
273/2/2022 20:01341900
283/2/2022 19:49342000
293/2/2022 19:48342100
303/2/2022 19:46342200
313/2/2022 19:45342300
323/2/2022 19:43342400
333/2/2022 19:31342500
343/2/2022 19:28342600
353/2/2022 19:27342700
363/2/2022 19:25342800
373/2/2022 19:20342900
383/2/2022 19:20343000
393/2/2022 19:11343100
403/2/2022 19:02343200
413/2/2022 18:46343300
423/2/2022 18:32343400
433/2/2022 18:19343500
443/2/2022 18:15343600
453/2/2022 18:14343700
463/2/2022 18:10343800
473/2/2022 18:07343900
483/2/2022 18:05344000
493/2/2022 17:47344100
503/2/2022 17:43344200
513/2/2022 16:59344300
523/2/2022 16:58344400
533/2/2022 16:56344500
543/2/2022 16:54344600
553/2/2022 16:49344700
563/2/2022 14:37344800
573/2/2022 14:31344900
583/2/2022 14:20345000
593/2/2022 14:18345100
603/2/2022 13:58345200
613/2/2022 13:56345300
623/2/2022 13:17345400
633/2/2022 13:15345500
643/2/2022 13:05345600
653/2/2022 13:03345700
663/2/2022 12:58345800
673/2/2022 12:56345900
683/2/2022 12:50346000
693/2/2022 12:39346100
703/2/2022 12:32346200
713/2/2022 12:24346300
723/2/2022 12:16346400
733/2/2022 12:12346500
743/2/2022 12:05346600
753/2/2022 11:54346700
763/2/2022 11:46346800
773/2/2022 11:16346900
783/2/2022 11:07347000
793/2/2022 11:00347100
803/2/2022 10:49347200
813/2/2022 10:41347300
823/2/2022 10:35347400
833/2/2022 10:34347500
843/2/2022 10:31347600
853/2/2022 10:14347700
863/2/2022 10:11347800
873/2/2022 10:05347900
883/2/2022 10:02348000
893/2/2022 9:59348100
903/2/2022 9:58348200
913/2/2022 0:05348300
923/2/2022 0:01348400
931/3/2022 23:45348500
941/3/2022 23:45348600
951/3/2022 23:26348700
961/3/2022 23:21348800
971/3/2022 23:10348900
981/3/2022 22:50349000
991/3/2022 22:47349100
1001/3/2022 22:46349200
1011/3/2022 22:43349300
1021/3/2022 22:40349400
1031/3/2022 22:25349500
1041/3/2022 22:23349600
1051/3/2022 22:23349700
1061/3/2022 22:21349800
1071/3/2022 22:20349900
1081/3/2022 22:19350000
1091/3/2022 22:18350100
1101/3/2022 22:17350200
1111/3/2022 22:14350300
1121/3/2022 21:36350400
1131/3/2022 21:34350500
1141/3/2022 21:33350600
1151/3/2022 21:25350700
1161/3/2022 21:24350800
1171/3/2022 21:18350900
1181/3/2022 20:42351000
1191/3/2022 20:40351100
1201/3/2022 20:36351200
1211/3/2022 20:35351300
1221/3/2022 20:33351400
1231/3/2022 20:33351500
1241/3/2022 20:30351600
1251/3/2022 20:25351700
1261/3/2022 20:01351800
1271/3/2022 19:56351900
1281/3/2022 19:54352000
1291/3/2022 19:53352100
1301/3/2022 19:53352200
1311/3/2022 19:52352300
1321/3/2022 19:51352400
1331/3/2022 19:45352500
1341/3/2022 19:43352600
1351/3/2022 19:41352700
1361/3/2022 19:38352800
1371/3/2022 19:38352900
1381/3/2022 19:31353000
1391/3/2022 19:30353100
1401/3/2022 19:27353200
1411/3/2022 19:25353300
1421/3/2022 19:12353400
1431/3/2022 19:11353500
1441/3/2022 19:10353600
1451/3/2022 19:05353700
1461/3/2022 19:03353800
1471/3/2022 19:01353900
1481/3/2022 19:00354000
1491/3/2022 19:00354100
1501/3/2022 18:57354200
1511/3/2022 18:38354300
1521/3/2022 18:36354400
1531/3/2022 18:32354500
1541/3/2022 18:31354600
1551/3/2022 18:29354700
1561/3/2022 18:21354800
1571/3/2022 18:20354900
1581/3/2022 18:17355000
1591/3/2022 18:17355100
1601/3/2022 18:15355200
1611/3/2022 18:07355300
1621/3/2022 17:58355400
1631/3/2022 17:58355500
1641/3/2022 17:32355600
1651/3/2022 17:29355700
1661/3/2022 17:24355800
1671/3/2022 17:20355900
1681/3/2022 17:15356000
1691/3/2022 17:07356100
1701/3/2022 17:01356200
1711/3/2022 16:54356300
1721/3/2022 16:41356400
1731/3/2022 15:54356500
1741/3/2022 15:53356600
1751/3/2022 15:51356700
1761/3/2022 15:41356800
1771/3/2022 15:38356900
1781/3/2022 15:35357000
1791/3/2022 15:33357100
1801/3/2022 15:21357200
1811/3/2022 15:18357300
1821/3/2022 15:12357400
1831/3/2022 14:25357500
1841/3/2022 14:24357600
1851/3/2022 13:39357700
1861/3/2022 12:59357800
1871/3/2022 12:58357900
1881/3/2022 12:57358000
1891/3/2022 12:56358100
1901/3/2022 12:51358200
1911/3/2022 12:22358300
1921/3/2022 12:20358400
1931/3/2022 12:19358500
1941/3/2022 11:55358600
1951/3/2022 11:24358700
1961/3/2022 11:23358800
1971/3/2022 11:04358900
1981/3/2022 11:03359000
1991/3/2022 10:59359100
2001/3/2022 10:52359200
2011/3/2022 10:45359300
2021/3/2022 10:42359400
2031/3/2022 10:27359500
2041/3/2022 10:00359600
2051/3/2022 9:57359700
2061/3/2022 9:38359800
2071/3/2022 9:30359900
2081/3/2022 8:55360000
2091/3/2022 8:45360100
2101/3/2022 8:28360200
2111/3/2022 1:22360300
2121/3/2022 1:15360400
2131/3/2022 1:13360500
2141/3/2022 1:13360600
2151/3/2022 1:13360700
2161/3/2022 1:11360800
2171/3/2022 1:08360900
2181/3/2022 1:06361000
2191/3/2022 1:03361100
2201/3/2022 1:03361200
2211/3/2022 0:47361300
2221/3/2022 0:24361400
2231/3/2022 0:19361500
2241/2/2022 23:59361600
2251/2/2022 23:53361700
2261/2/2022 23:49361800
2271/2/2022 23:48361900
2281/2/2022 23:48362000
2291/2/2022 23:44362100
2301/2/2022 23:41362200
2311/2/2022 23:39362300
2321/2/2022 23:34362400
2331/2/2022 23:33362500
2341/2/2022 23:32362600
2351/2/2022 23:19362700
2361/2/2022 23:16362800
2371/2/2022 22:32362900
2381/2/2022 22:27363000
2391/2/2022 22:17363100
2401/2/2022 22:12363200
2411/2/2022 22:12363300
2421/2/2022 22:11363400
2431/2/2022 21:51363500
2441/2/2022 21:50363600
2451/2/2022 21:50363700
2461/2/2022 21:48363800
2471/2/2022 21:47363900
2481/2/2022 21:46364000
2491/2/2022 21:45364100
2501/2/2022 21:44364200
2511/2/2022 21:41364300
2521/2/2022 21:40364400
2531/2/2022 21:38364500
2541/2/2022 21:35364600
2551/2/2022 21:28364700
2561/2/2022 21:10364800
2571/2/2022 21:05364900
2581/2/2022 21:04365000
2591/2/2022 21:02365100
2601/2/2022 21:01365200
2611/2/2022 21:00365300
2621/2/2022 20:59365400
2631/2/2022 20:53365500
2641/2/2022 20:00365600
2651/2/2022 19:57365700
2661/2/2022 19:54365800
2671/2/2022 19:52365900
2681/2/2022 19:51366000
2691/2/2022 19:49366100
2701/2/2022 19:48366200
2711/2/2022 19:47366300
2721/2/2022 19:46366400
2731/2/2022 19:45366500
2741/2/2022 19:45366600
2751/2/2022 19:41366700
2761/2/2022 19:29366800
2771/2/2022 19:28366900
2781/2/2022 19:17367000
2791/2/2022 19:16367100
2801/2/2022 19:11367200
2811/2/2022 19:07367300
2821/2/2022 19:03367400
2831/2/2022 18:57367500
2841/2/2022 18:23367600
2851/2/2022 18:17367700
2861/2/2022 17:19367800
2871/2/2022 17:18367900
2881/2/2022 17:03368000
2891/2/2022 16:55368100
2901/2/2022 16:47368200
2911/2/2022 16:45368300
2921/2/2022 16:41368400
2931/2/2022 16:27368500
2941/2/2022 16:12368600
2951/2/2022 16:03368700
2961/2/2022 15:40368800
2971/2/2022 15:24368900
2981/2/2022 15:17369000
2991/2/2022 14:02369100
3001/2/2022 13:58369200
3011/2/2022 12:57369300
3021/2/2022 12:33369400
3031/2/2022 12:28369500
3041/2/2022 12:27369600
3051/2/2022 10:55369700
3061/2/2022 10:35369800
3071/2/2022 10:30369900
3081/2/2022 10:25370000
3091/2/2022 10:19370100
3101/2/2022 10:14370200
3111/2/2022 10:07370300
3121/2/2022 10:02370400
3131/2/2022 9:49370500
3141/2/2022 8:38370600
3151/2/2022 8:34370700
3161/2/2022 8:30370800
3171/2/2022 8:26370900
3181/2/2022 8:21371000
3191/2/2022 8:15371100
3201/2/2022 8:09371200
3211/2/2022 8:03371300
3221/2/2022 7:58371400
3231/2/2022 3:30371500
3241/2/2022 3:25371600
3251/2/2022 3:20371700
3261/2/2022 3:15371800
3271/2/2022 3:08371900
3281/2/2022 1:32372000
3291/2/2022 1:20372100
3301/2/2022 1:18372200
3311/2/2022 1:11372300
3321/2/2022 1:11372400
3331/2/2022 1:07372500
3341/2/2022 1:04372600
3351/2/2022 1:03372700
3361/2/2022 0:56372800
3371/2/2022 0:51372900
3381/2/2022 0:50373000
3391/2/2022 0:43373100
3401/2/2022 0:43373200
3411/2/2022 0:34373300
Sheet1
Cell Formulas
RangeFormula
E4E4=SUMIFS(B:B,A:A,">="&D2,A:A,"<="&E2)
Named Ranges
NameRefers ToCells
_FilterDatabase=Sheet1!$A$1:$B$341E4
Thanks much Sufiyan.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,096
Messages
5,852,153
Members
431,488
Latest member
ePayslip

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top