How to get value with most recent date in an array

[lost_in_the_sauce]

Thought I had it before, but didn't, have the xl2bb add in now.

I have tons of financial data for store locations that is entered by the stores into SalesForce, and if they make an additional entry it just adds it to the data stack, so a store could have multiple entries for one month. I would like to pull the values of only the latest dated entry, right now it's capturing all and adding them together for the same month.

Data tab:

mrexcel2bb.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	SalesforceID	Month	Fiscal Month	Year	Store	Location	Created Date	Sync to SF	Name	Revenue	COGS	Insurance	Marketing	Occupancy	Other	Payroll	Excluded Items (Not Required)
2	a085f000008MmAQAA0	December	P-12 (Dec)	2022	40	New York	01/23/23 10:45 AM		Billy Williamson	$ 192,735.00	$ 22,291.72	$ 21,205.48	$ 3,375.00	$ 43,879.60	$ 44,517.16	$ 47,603.52	$ (47,880.83)
3	a085f000006xZVgAAM	November	P-11 (Nov)	2022	40	New York	12/23/22 3:38 AM		Billy Williamson	$ 135,080.88	$ 13,843.69	$ 6,691.17	$ -	$ 38,642.48	$ 34,806.04	$ 41,462.35	$ (28,129.07)
4	a085f000006w2stAAA	October	P-10 (Oct)	2022	40	New York	11/22/22 9:04 AM		Billy Williamson	$ 145,888.34	$ 18,839.01	$ 6,847.02	$ -	$ 40,512.60	$ 35,565.12	$ 42,675.61	$ (28,152.08)
5	a085f000006ui4WAAQ	September	P-09 (Sep)	2022	40	New York	10/25/22 6:33 AM		Billy Williamson	$ 162,578.36	$ 24,342.38	$ 6,691.17	$ -	$ 42,091.25	$ 28,153.80	$ 64,873.11	$ (28,175.02)
6	a085f000005L7lHAAS	August	P-08 (Aug)	2022	40	New York	09/24/22 5:14 AM		Billy Williamson	$ 176,873.57	$ 25,586.87	$ 6,691.00	$ 750.00	$ 76,501.00	$ 40,558.81	$ 52,668.56	$ (33,281.41)
7	a085f000005JsDWAA0	March	P-03 (Mar)	2022	40	New York	08/24/22 11:30 AM		Billy Williamson	$ 175,923.11	$ 18,115.21	$ 6,691.17	$ 750.00	$ 41,042.35	$ 45,630.51	$ 62,623.68	$ (30,128.32)
8	a085f000005Ioy0AAC	June	P-06 (Jun)	2022	40	New York	07/25/22 4:04 PM		Billy Williamson	$ 218,278.43	$ 52,183.63	$ 7,452.62	$ 750.00	$ 44,795.30	$ 28,897.88	$ 63,371.42	$ (30,150.87)
9	a085f000005HkQkAAK	May	P-05 (May)	2022	40	New York	06/23/22 5:45 AM		Billy Williamson	$ 167,541.00	$ 25,259.99	$ 12,059.00	$ 750.00	$ 41,532.00	$ 29,953.88	$ 39,598.00	$ (30,173.00)
10	a085f000003yoDuAAI	April	P-04 (Apr)	2022	40	New York	05/19/22 5:41 AM		Billy Williamson	$ 138,502.82	$ 23,034.05	$ 5,365.02	$ 750.00	$ 37,013.81	$ 38,702.24	$ 37,941.87	$ 32,104.91
11	a085f000003xwkLAAQ	March	P-03 (Mar)	2022	40	New York	04/25/22 2:09 PM		Billy Williamson	$ 237,193.86	$ 19,501.47	$ 5,528.65	$ 750.00	$ 42,506.31	$ 26,449.44	$ 69,335.82	$ 30,173.16
12	a085f000003xJVLAA2	February	P-02 (Feb)	2022	40	New York	04/14/22 3:03 AM		Billy Williamson	$ 146,176.00	$ 14,426.00	$ 5,365.00	$ -	$ 38,604.00	$ 24,684.00	$ 42,830.00	$ 3,538.00
13	a085f000003xJVGAA2	January	P-01 (Jan)	2022	40	New York	04/14/22 3:00 AM		Billy Williamson	$ 161,274.00	$ 10,436.00	$ 5,360.00	$ (5.00)	$ 37,966.00	$ 19,897.00	$ 47,289.00	$ 3,558.00
14	a085f000008KA0NAAW	December	P-12 (Dec)	2022	149	Boston	01/14/23 6:42 AM		Jennifer Harper	$ 338,912.46	$ 32,502.00	$ 18,932.49	$ 14,740.95	$ 29,448.49	$ 46,288.74	$ 68,477.32	$ 41,399.19
15	a085f000006xDOTAA2	November	P-11 (Nov)	2022	149	Boston	12/14/22 6:41 PM		Jennifer Harper	$ 296,919.99	$ 40,386.12	$ 27,623.49	$ 10,940.16	$ 29,488.46	$ 36,496.14	$ 66,723.66	$ 33,631.62
16	a085f000006vmL0AAI	October	P-10 (Oct)	2022	149	Boston	11/13/22 6:29 AM		Jennifer Harper	$ 233,850.14	$ 27,223.88	$ 15,649.58	$ 9,884.19	$ 30,769.69	$ 41,930.75	$ 59,687.90	$ 31,949.46
17	a085f000006uJ6fAAE	September	P-09 (Sep)	2022	149	Boston	10/14/22 5:25 PM		Jennifer Harper	$ 231,854.36	$ 28,646.54	$ 16,272.58	$ 12,328.60	$ 30,098.07	$ 28,310.26	$ 85,946.05	$ 38,962.18
18	a085f000005KjLQAA0	August	P-08 (Aug)	2022	149	Boston	09/15/22 7:33 PM		Jennifer Harper	$ 268,894.48	$ 33,632.51	$ 22,096.47	$ 15,808.20	$ 30,131.91	$ 30,743.10	$ 68,464.22	$ 37,612.55
19	a085f000005JsbhAAC	July	P-07 (Jul)	2022	149	Boston	08/24/22 3:24 PM		Jennifer Harper	$ 254,189.52	$ 32,123.62	$ 17,584.58	$ 10,499.99	$ 30,840.77	$ 27,781.32	$ 141,766.70	$ 9,976.71
20	a085f000005JYsGAAW	July	P-07 (Jul)	2022	149	Boston	08/16/22 3:48 AM		Jennifer Harper	$ 254,189.52	$ 32,123.62	$ 17,584.58	$ 10,499.99	$ 25,000.00	$ 33,622.09	$ 141,766.70	$ 9,976.71
21	a085f000005INRqAAO	June	P-06 (Jun)	2022	149	Boston	07/11/22 6:56 AM		Jennifer Harper	$ 225,493.72	$ 25,714.29	$ 17,025.58	$ 11,304.88	$ 29,310.71	$ 34,690.73	$ 74,935.64	$ 32,407.53
22	a085f000003zeEBAAY	May	P-05 (May)	2022	149	Boston	06/11/22 6:12 AM		Jennifer Harper	$ 275,129.77	$ 41,830.16	$ 16,560.73	$ 17,279.13	$ 29,565.93	$ 54,363.81	$ 68,441.44	$ 46,516.64
23	a085f000003yjC2AAI	April	P-04 (Apr)	2022	149	Boston	05/17/22 5:17 AM		Jennifer Harper	$ 412,691.43	$ 67,780.67	$ 13,040.13	$ 20,804.93	$ 30,963.31	$ 54,456.62	$ 73,053.48	$ 41,999.08
24	a085f000003yiQJAAY	February	P-02 (Feb)	2022	149	Boston	05/16/22 6:04 PM		Jennifer Harper	$ 385,871.20	$ 42,053.61	$ 927.88	$ 14,977.19	$ 30,170.55	$ 38,358.98	$ 59,355.08	$ 39,760.42
25	a085f000003yiQEAAY	January	P-01 (Jan)	2022	149	Boston	05/16/22 6:03 PM		Jennifer Harper	$ 341,716.77	$ 34,586.19	$ 11,865.13	$ 14,525.83	$ 30,877.99	$ 32,690.87	$ 68,137.94	$ 41,770.64
26	a085f000003yiQ9AAI	February	P-02 (Feb)	2022	149	Boston	05/16/22 6:00 PM		Jennifer Harper	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
27	a085f000003yiPzAAI	January	P-01 (Jan)	2022	149	Boston	05/16/22 5:59 PM		Jennifer Harper	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
28	a085f000003xFTrAAM	March	P-03 (Mar)	2022	149	Boston	04/11/22 2:20 AM		Jennifer Harper	$ 494,203.40	$ 62,226.56	$ 23,943.88	$ 31,577.96	$ 30,383.40	$ 68,943.51	$ 109,204.92	$ 39,872.20
29	a085f000001KIHtAAO	February	P-02 (Feb)	2022	149	Boston	03/12/22 5:11 PM		Jennifer Harper	$ 385,871.20	$ 42,053.61	$ 927.88	$ 14,977.19	$ 30,170.55	$ 38,358.98	$ 59,355.08	$ 39,760.42
30	a085f000001KHLgAAO	February	P-02 (Feb)	2022	149	Boston	03/10/22 2:21 PM		Jennifer Harper	$ 533,071.54	$ 42,053.61	$ 927.88	$ 14,977.19	$ 30,170.55	$ 38,358.98	$ 59,355.08	$ 39,760.42
31	a085f000001KCI8AAO	January	P-01 (Jan)	2022	149	Boston	02/20/22 1:43 PM		Jennifer Harper	$ 341,716.77	$ 34,586.19	$ 11,865.13	$ 14,525.83	$ 30,877.99	$ 32,690.87	$ 68,137.94	$ 41,770.64
32	a085f000008MqH5AAK	December	P-12 (Dec)	2022	107	Philadelphia	01/24/23 10:20 AM		Max Headroom	$ 435,436.86	$ 44,980.68	$ 20,070.23	$ 8,250.00	$ 110,877.82	$ 75,328.75	$ 81,596.21	$ 166.06
33	a085f000006xcpmAAA	November	P-11 (Nov)	2022	107	Philadelphia	12/25/22 9:56 PM		Max Headroom	$ 395,724.61	$ 53,529.86	$ 21,235.76	$ 8,250.00	$ 51,969.51	$ 45,789.75	$ 72,083.99	$ 136.88
34	a085f000006wDESAA2	October	P-10 (Oct)	2022	107	Philadelphia	11/25/22 6:40 AM		Max Headroom	$ 430,768.19	$ 42,405.88	$ 22,177.76	$ 8,541.10	$ 52,742.63	$ 46,956.82	$ 73,414.45	$ 109.22
35	a085f000006ujmyAAA	September	P-09 (Sep)	2022	107	Philadelphia	10/25/22 10:16 PM		Max Headroom	$ 409,705.58	$ 46,034.77	$ 27,537.26	$ 8,225.00	$ 54,945.82	$ 48,811.23	$ 74,875.91	$ 80.58
36	a085f000005L9K3AAK	August	P-08 (Aug)	2022	107	Philadelphia	09/25/22 8:56 PM		Max Headroom	$ 429,828.82	$ 60,872.14	$ 23,133.36	$ 8,250.00	$ 58,834.81	$ 45,057.14	$ 75,376.04	$ 106.31
37	a085f000005JxeNAAS	July	P-07 (Jul)	2022	107	Philadelphia	08/25/22 9:41 PM		Max Headroom	$ 501,857.61	$ 54,367.37	$ 20,153.43	$ 8,318.03	$ 57,758.48	$ 47,967.54	$ 86,919.53	$ 50.55
38	a085f000005IpHHAA0	June	P-06 (Jun)	2022	107	Philadelphia	07/25/22 9:40 PM		Max Headroom	$ 456,591.94	$ 44,718.55	$ 23,518.73	$ 8,319.59	$ 58,774.48	$ 43,056.01	$ 86,071.99
39	a085f000005HrdDAAS	May	P-05 (May)	2022	107	Philadelphia	06/25/22 9:07 PM		Max Headroom	$ 451,295.10	$ 44,279.82	$ 19,199.43	$ 8,998.20	$ 54,327.96	$ 41,536.08	$ 69,477.99	$ 39.23
40	a085f000003z5E1AAI	April	P-04 (Apr)	2022	107	Philadelphia	05/25/22 6:03 PM		Max Headroom	$ 497,385.30	$ 55,366.18	$ 8,517.00	$ 8,863.46	$ 52,477.92	$ 45,319.51	$ 71,448.25	$ 29.55
41	a085f000003xwwqAAA	March	P-03 (Mar)	2022	107	Philadelphia	04/25/22 9:31 PM		Max Headroom	$ 662,606.13	$ 86,417.45	$ 15,000.82	$ 8,323.03	$ 55,790.61	$ 60,001.31	$ 73,809.61
42	a085f000003qMdyAAE	February	P-02 (Feb)	2022	107	Philadelphia	04/01/22 11:28 PM		Max Headroom	$ 480,993.82	$ 39,475.62	$ 3,226.00	$ 8,260.00	$ 54,253.31	$ 48,160.16	$ 62,486.30
43	a085f000001KEkVAAW	January	P-01 (Jan)	2022	107	Philadelphia	02/25/22 9:35 PM		Max Headroom	$ 423,092.57	$ 33,460.85	$ 6,483.82	$ 9,021.18	$ 45,986.08	$ 45,622.93	$ 68,282.83	$ 17.94
44	a085f000008KEX4AAO	December	P-12 (Dec)	2022	93	Atlanta	01/16/23 8:51 AM		Frank Drebin	$ 181,731.00	$ 11,958.00	$ 7,860.00	$ 29,450.00	$ 26,427.00	$ 18,744.00	$ 34,195.00	$ 13,949.00
45	a085f000006xEh3AAE	November	P-11 (Nov)	2022	93	Atlanta	12/15/22 6:15 AM		Frank Drebin	$ 175,151.00	$ 30,118.00	$ 7,859.00	$ 14,966.00	$ 32,333.00	$ 32,368.00	$ 29,430.00
46	a085f000006vryKAAQ	October	P-10 (Oct)	2022	93	Atlanta	11/15/22 1:10 PM		Frank Drebin	$ 132,686.00	$ 15,816.00	$ 8,049.00	$ 8,910.00	$ 27,505.00	$ 16,150.00	$ 26,225.00
47	a085f000006ufWGAAY	September	P-09 (Sep)	2022	93	Atlanta	10/24/22 7:31 AM		Frank Drebin	$ 122,938.00	$ 17,704.00	$ 7,859.00	$ 7,294.00	$ 30,305.00	$ 18,068.00	$ 25,647.00
48	a085f000005L3FUAA0	August	P-08 (Aug)	2022	93	Atlanta	09/23/22 8:10 AM		Frank Drebin	$ 168,097.00	$ 19,772.00	$ 9,086.00	$ 8,956.00	$ 31,410.00	$ 18,579.00	$ 32,224.00	$ 15,807.00
49	a085f000005JmMTAA0	July	P-07 (Jul)	2022	93	Atlanta	08/22/22 8:28 AM		Frank Drebin	$ 155,530.00	$ 11,499.00	$ 10,199.00	$ 7,496.00	$ 31,626.00	$ 16,974.00	$ 30,066.00
50	a085f000005IpkfAAC	January	P-01 (Jan)	2022	93	Atlanta	07/26/22 5:32 AM		Frank Drebin	$ 160,089.00	$ 15,741.00	$ 847.00	$ 6,519.00	$ 29,879.00	$ 18,632.00	$ 28,332.00	$ 4,224.00
51	a085f000005HoG7AAK	May	P-05 (May)	2022	93	Atlanta	06/24/22 12:16 PM		Frank Drebin	$ 157,406.00	$ 26,797.00	$ 10,511.00	$ 9,881.00	$ 26,600.00	$ 16,349.00	$ 27,129.00	$ 5,707.00
52	a085f000005HehXAAS	January	P-01 (Jan)	2022	93	Atlanta	06/21/22 4:58 PM		Frank Drebin	$ 157,406.00	$ 26,797.00	$ 10,510.00	$ 9,872.34	$ 28,313.11	$ 14,616.75	$ 27,130.00	$ 5,707.80
53	a085f000003ylwkAAA	April	P-04 (Apr)	2022	93	Atlanta	05/18/22 5:18 AM		Frank Drebin	$ 200,413.33	$ 24,278.42	$ 2,591.00	$ 13,138.00	$ 24,417.00	$ 24,204.00	$ 27,860.00
54	a085f000003xZERAA2	March	P-03 (Mar)	2022	93	Atlanta	04/16/22 12:52 PM		Frank Drebin	$ 224,692.00	$ 22,281.00	$ 619.00	$ 11,824.00	$ 38,569.00	$ 11,027.00	$ 25,075.00
55	a085f000001KHGFAA4	February	P-02 (Feb)	2022	93	Atlanta	03/10/22 10:09 AM		Frank Drebin	$ 204,835.44	$ 22,930.20	$ 1,231.50	$ 11,696.32	$ 11,021.09	$ 38,977.95	$ 23,315.95
56	a085f000001KF4LAAW	January	P-01 (Jan)	2022	93	Atlanta	02/28/22 2:28 PM		Frank Drebin	$ 183,615.70	$ 23,550.00	$ -	$ 8,016.90	$ 21,414.96	$ 21,403.72	$ 24,717.71
57	a085f000008MtCjAAK	December	P-12 (Dec)	2022	146	Miami	01/25/23 8:57 PM		Jim Smith	$ 299,055.00	$ 22,943.00	$ 13,364.00	$ 12,131.00	$ 40,777.00	$ 39,653.00	$ 39,091.00	$ 7,943.00
58	a085f000006xZtFAAU	November	P-11 (Nov)	2022	146	Miami	12/23/22 2:42 PM		Jim Smith	$ 287,756.00	$ 23,526.00	$ 12,672.00	$ 14,073.00	$ 41,205.00	$ 28,766.00	$ 38,500.00	$ 2,257.00
59	a085f000006wDuFAAU	October	P-10 (Oct)	2022	146	Miami	11/25/22 6:30 PM		Jim Smith	$ 255,486.00	$ 25,891.00	$ 13,348.00	$ 9,408.00	$ 41,423.00	$ 26,829.00	$ 45,392.00	$ 2,222.00
60	a085f000006uipQAAQ	September	P-09 (Sep)	2022	146	Miami	10/25/22 4:18 PM		Jim Smith	$ 236,993.44	$ 25,996.96	$ 12,354.73	$ 13,724.60	$ 41,102.24	$ 27,521.20	$ 61,801.82	$ 8,138.56
61	a085f000005KmU0AAK	August	P-08 (Aug)	2022	146	Miami	09/17/22 7:49 AM		Jim Smith	$ 312,720.58	$ 34,497.36	$ 13,214.78	$ 11,291.88	$ 41,655.30	$ 35,495.27	$ 55,355.18	$ -
62	a085f000005Jb97AAC	July	P-07 (Jul)	2022	146	Miami	08/17/22 9:39 AM		Jim Smith	$ 241,411.59	$ 24,905.23	$ 11,536.88	$ 9,313.60	$ 41,482.00	$ 21,209.63	$ 55,038.26	$ -
63	a085f000005INNtAAO	June	P-06 (Jun)	2022	146	Miami	07/11/22 4:04 AM		Jim Smith	$ 231,073.61	$ 26,743.14	$ 12,634.68	$ 24,531.37	$ 40,454.62	$ 19,969.68	$ 45,152.81	$ -
64	a085f000005HShPAAW	May	P-05 (May)	2022	146	Miami	06/15/22 6:08 PM		Jim Smith	$ 240,856.45	$ 31,358.08	$ 19,741.89	$ 20,077.46	$ 39,927.34	$ 43,039.82	$ 39,668.55	$ -
65	a085f000003yeNtAAI	April	P-04 (Apr)	2022	146	Miami	05/13/22 10:45 AM		Jim Smith	$ 278,005.22	$ 15,396.70	$ 9,137.67	$ 20,014.81	$ 39,969.64	$ 36,559.80	$ 44,342.02
66	a085f000003xFU6AAM	March	P-03 (Mar)	2022	146	Miami	04/11/22 5:30 AM		Jim Smith	$ 498,884.02	$ 47,821.51	$ 9,357.52	$ 12,260.29	$ 41,668.86	$ 25,150.85	$ 70,838.10
67	a085f000001KI1UAAW	February	P-02 (Feb)	2022	146	Miami	03/12/22 5:33 AM		Jim Smith	$ 302,544.22	$ 38,977.16	$ 10,801.83	$ 14,676.18	$ 41,438.72	$ 25,170.46	$ 40,603.18	$ -
68	a085f000001K9lwAAC	January	P-01 (Jan)	2022	146	Miami	02/11/22 12:13 PM		Jim Smith	$ 267,984.24	$ 28,329.22	$ 9,357.52	$ 18,849.97	$ 40,669.04	$ 26,012.31	$ 39,333.35	$ -
Data

Dashboard tab:

mrexcel2bb.xlsx
	B	C	D	E	F	G	H	I	J
1	New York	Revenue	COGS	Gross Profit	Payroll	Marketing	Insurance	Occupancy	Other
2	January	$ 161,274	$ 10,436	$ 150,838	$ 47,289	$ (5)	$ 5,360	$ 37,966	$ 19,897
3	February	$ 146,176	$ 14,426	$ 131,750	$ 42,830	$ -	$ 5,365	$ 38,604	$ 24,684
4	March	$ 413,117	$ 37,617	$ 375,500	$ 131,960	$ 1,500	$ 12,220	$ 83,549	$ 72,080
5	April	$ 138,503	$ 23,034	$ 115,469	$ 37,942	$ 750	$ 5,365	$ 37,014	$ 38,702
6	May	$ 167,541	$ 25,260	$ 142,281	$ 39,598	$ 750	$ 12,059	$ 41,532	$ 29,954
7	June	$ 218,278	$ 52,184	$ 166,095	$ 63,371	$ 750	$ 7,453	$ 44,795	$ 28,898
8	July	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
9	August	$ 176,874	$ 25,587	$ 151,287	$ 52,669	$ 750	$ 6,691	$ 76,501	$ 40,559
10	September	$ 162,578	$ 24,342	$ 138,236	$ 64,873	$ -	$ 6,691	$ 42,091	$ 28,154
11	October	$ 145,888	$ 18,839	$ 127,049	$ 42,676	$ -	$ 6,847	$ 40,513	$ 35,565
12	November	$ 135,081	$ 13,844	$ 121,237	$ 41,462	$ -	$ 6,691	$ 38,642	$ 34,806
13	December	$ 192,735	$ 22,292	$ 170,443	$ 47,604	$ 3,375	$ 21,205	$ 43,880	$ 44,517
14
15	Boston	Revenue	COGS	Gross Profit	Payroll	Marketing	Insurance	Occupancy	Other
16	January	$ 683,434	$ 69,172	$ 614,261	$ 136,276	$ 29,052	$ 23,730	$ 61,756	$ 65,382
17	February	$ 1,304,814	$ 126,161	$ 1,178,653	$ 178,065	$ 44,932	$ 2,784	$ 90,512	$ 115,077
18	March	$ 494,203	$ 62,227	$ 431,977	$ 109,205	$ 31,578	$ 23,944	$ 30,383	$ 68,944
19	April	$ 412,691	$ 67,781	$ 344,911	$ 73,053	$ 20,805	$ 13,040	$ 30,963	$ 54,457
20	May	$ 275,130	$ 41,830	$ 233,300	$ 68,441	$ 17,279	$ 16,561	$ 29,566	$ 54,364
21	June	$ 225,494	$ 25,714	$ 199,779	$ 74,936	$ 11,305	$ 17,026	$ 29,311	$ 34,691
22	July	$ 508,379	$ 64,247	$ 444,132	$ 283,533	$ 21,000	$ 35,169	$ 55,841	$ 61,403
23	August	$ 268,894	$ 33,633	$ 235,262	$ 68,464	$ 15,808	$ 22,096	$ 30,132	$ 30,743
24	September	$ 231,854	$ 28,647	$ 203,208	$ 85,946	$ 12,329	$ 16,273	$ 30,098	$ 28,310
25	October	$ 233,850	$ 27,224	$ 206,626	$ 59,688	$ 9,884	$ 15,650	$ 30,770	$ 41,931
26	November	$ 296,920	$ 40,386	$ 256,534	$ 66,724	$ 10,940	$ 27,623	$ 29,488	$ 36,496
27	December	$ 338,912	$ 32,502	$ 306,410	$ 68,477	$ 14,741	$ 18,932	$ 29,448	$ 46,289
View

Cell Formulas
Range	Formula
C2:D13,F2:J13	C2	=SUMPRODUCT((Data!$B$2:$B$68=View!$B2)*(Data!$J$1:$Q$1=View!C$1)*(Data!$F$2:$F$68=View!$B$1)*(Data!$J$2:$Q$68))
E2:E13,E16:E27	E2	=C2-D2
C16:D27,F16:J27	C16	=SUMPRODUCT((Data!$B$2:$B$68=View!$B16)*(Data!$J$1:$Q$1=View!C$15)*(Data!$F$2:$F$68=View!$B$15)*(Data!$J$2:$Q$68))

You can see for example, Feb for Boston is the sum of all the entries for Feb, when I only want to pull values of the latest upload, which is 5/16/22 6:04 PM. Trying to get this to work so that in the future I won't have to clean up the data for hundreds of stores.

 

[Fluff]

How about

Fluff.xlsm
	B	C	D	E
15	Boston	Revenue	COGS	Gross Profit
16	January	341716.8	34586.19	307130.6
17	February	385871.2	42053.61	343817.6
18	March	494203.4	62226.56	431976.8
19	April	412691.4	67780.67	344910.8
20	May	275129.8	41830.16	233299.6
21	June	225493.7	25714.29	199779.4
22	July	254189.5	32123.62	222065.9
23	August	268894.5	33632.51	235262
24	September	231854.4	28646.54	203207.8
25	October	233850.1	27223.88	206626.3
26	November	296920	40386.12	256533.9
27	December	338912.5	32502	306410.5
View

Cell Formulas
Range	Formula
C16:D27	C16	=TAKE(SORT(FILTER(FILTER(Data!$G$2:$Q$68,(Data!$B$2:$B$68=$B16)*(Data!$F$2:$F$68=$B$15)),(Data!$G$1:$Q$1=C$15)+(Data!$G$1:$Q$1="Created Date")),,-1),1,-1)
E16:E27	E16	=C16-D16

 

[DanteAmor]

Try this:

varios 27feb2023.xlsm
	A	B	C	D	E	F	G	H	I
1	New York	Revenue	COGS	Insurance	Marketing	Occupancy	Other	Payroll	Excluded Items (Not Required)
2	January	161274.00	10436.00	5360.00	0.00	37966.00	19897.00	47289.00	3558.00
3	February	146176.00	14426.00	5365.00	0.00	38604.00	24684.00	42830.00	3538.00
4	March	175923.11	18115.21	6691.17	750.00	41042.35	45630.51	62623.68	0.00
5	April	138502.82	23034.05	5365.02	750.00	37013.81	38702.24	37941.87	32104.91
6	May	167541.00	25259.99	12059.00	750.00	41532.00	29953.88	39598.00	0.00
7	June	218278.43	52183.63	7452.62	750.00	44795.30	28897.88	63371.42	0.00
8	July	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
9	August	176873.57	25586.87	6691.00	750.00	76501.00	40558.81	52668.56	0.00
10	September	162578.36	24342.38	6691.17	0.00	42091.25	28153.80	64873.11	0.00
11	October	145888.34	18839.01	6847.02	0.00	40512.60	35565.12	42675.61	0.00
12	November	135080.88	13843.69	6691.17	0.00	38642.48	34806.04	41462.35	0.00
13	December	192735.00	22291.72	21205.48	3375.00	43879.60	44517.16	47603.52	0.00
14
15	Boston	Revenue	COGS	Insurance	Marketing	Occupancy	Other	Payroll	Excluded Items (Not Required)
16	January	341716.77	34586.19	11865.13	14525.83	30877.99	32690.87	68137.94	41770.64
17	February	385871.20	42053.61	927.88	14977.19	30170.55	38358.98	59355.08	39760.42
18	March	494203.40	62226.56	23943.88	31577.96	30383.40	68943.51	109204.92	39872.20
19	April	412691.43	67780.67	13040.13	20804.93	30963.31	54456.62	73053.48	41999.08
20	May	275129.77	41830.16	16560.73	17279.13	29565.93	54363.81	68441.44	46516.64
21	June	225493.72	25714.29	17025.58	11304.88	29310.71	34690.73	74935.64	32407.53
22	July	254189.52	32123.62	17584.58	10499.99	30840.77	27781.32	141766.70	9976.71
23	August	268894.48	33632.51	22096.47	15808.20	30131.91	30743.10	68464.22	37612.55
24	September	231854.36	28646.54	16272.58	12328.60	30098.07	28310.26	85946.05	38962.18
25	October	233850.14	27223.88	15649.58	9884.19	30769.69	41930.75	59687.90	31949.46
26	November	296919.99	40386.12	27623.49	10940.16	29488.46	36496.14	66723.66	33631.62
27	December	338912.46	32502.00	18932.49	14740.95	29448.49	46288.74	68477.32	41399.19
View

Cell Formulas
Range	Formula
B2:I13	B2	=MAX((Data!$F$2:$F$68=$A$1)*(Data!$B$2:$B$68=$A2)*(Data!$G$2:$G$68=MAX((Data!$F$2:$F$68=$A$1)*(Data!$B$2:$B$68=$A2)*(Data!$G$2:$G$68)))*(Data!$J$1:$Q$1=B$1)*Data!$J$2:$Q$68)
B16:I27	B16	=MAX((Data!$F$2:$F$68=$A$15)*(Data!$B$2:$B$68=$A16)*(Data!$G$2:$G$68=MAX((Data!$F$2:$F$68=$A$15)*(Data!$B$2:$B$68=$A16)*(Data!$G$2:$G$68)))*(Data!$J$1:$Q$1=B$15)*Data!$J$2:$Q$68)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[DanteAmor]

Try:

Dante Amor
	A	B	C
1	New York	Revenue	COGS
2	January	161274.00	10436.00
3	February	146176.00	14426.00
4	March	175923.11	18115.21
5	April	138502.82	23034.05
6	May	167541.00	25259.99
7	June	218278.43	52183.63
8	July	0.00	0.00
9	August	176873.57	25586.87
10	September	162578.36	24342.38
11	October	145888.34	18839.01
12	November	135080.88	13843.69
13	December	192735.00	22291.72
14
15	Boston	Revenue	COGS
16	January	341716.77	34586.19
17	February	385871.20	42053.61
18	March	494203.40	62226.56
19	April	412691.43	67780.67
20	May	275129.77	41830.16
21	June	225493.72	25714.29
22	July	254189.52	32123.62
23	August	268894.48	33632.51
24	September	231854.36	28646.54
25	October	233850.14	27223.88
26	November	296919.99	40386.12
27	December	338912.46	32502.00
View

Cell Formulas
Range	Formula
B2:C13	B2	=MAX((Data!$F$2:$F$68=$A$1)*(Data!$B$2:$B$68=$A2)*(Data!$G$2:$G$68=MAX((Data!$F$2:$F$68=$A$1)*(Data!$B$2:$B$68=$A2)*(Data!$G$2:$G$68)))*(Data!$J$1:$Q$1=B$1)*Data!$J$2:$Q$68)
B16:C27	B16	=MAX((Data!$F$2:$F$68=$A$15)*(Data!$B$2:$B$68=$A16)*(Data!$G$2:$G$68=MAX((Data!$F$2:$F$68=$A$15)*(Data!$B$2:$B$68=$A16)*(Data!$G$2:$G$68)))*(Data!$J$1:$Q$1=B$15)*Data!$J$2:$Q$68)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[lost_in_the_sauce]

My man!!!

 

[lost_in_the_sauce]

How about

Fluff.xlsm
	B	C	D	E
15	Boston	Revenue	COGS	Gross Profit
16	January	341716.8	34586.19	307130.6
17	February	385871.2	42053.61	343817.6
18	March	494203.4	62226.56	431976.8
19	April	412691.4	67780.67	344910.8
20	May	275129.8	41830.16	233299.6
21	June	225493.7	25714.29	199779.4
22	July	254189.5	32123.62	222065.9
23	August	268894.5	33632.51	235262
24	September	231854.4	28646.54	203207.8
25	October	233850.1	27223.88	206626.3
26	November	296920	40386.12	256533.9
27	December	338912.5	32502	306410.5
View

Cell Formulas
Range	Formula
C16:D27	C16	=TAKE(SORT(FILTER(FILTER(Data!$G$2:$Q$68,(Data!$B$2:$B$68=$B16)*(Data!$F$2:$F$68=$B$15)),(Data!$G$1:$Q$1=C$15)+(Data!$G$1:$Q$1="Created Date")),,-1),1,-1)
E16:E27	E16	=C16-D16

This did it. Thank you Fluff

 

[Fluff]

Glad we could help & thanks for the feedback.