Calculating sum based on month and year

Using Power Query in the attached is the full solution, but I am only showing two years of summary in the thread.

Excel 2016 (Windows) 64 bit

	A	B	C
1	Status	Month:Year	Totals
2	INACTIVE	May:2017	49367
3	WON	May:2017	43345
4	INACTIVE	June:2017	69089
5	WON	June:2017	19387
6	WON	July:2017	6215
7	LOST	July:2017	6591
8	WON	August:2017	15506
9	LOST	August:2017	70000
10	INACTIVE	October:2017	81213
11	WON	October:2017	19650
12	INACTIVE	November:2017	21800
13	INACTIVE	December:2017	60975
14	WON	December:2017	36190
15	INACTIVE	January:2018	49955
16	LOST	January:2018	37740
17	WON	January:2018	6750
18	INACTIVE	February:2018	33358
19	WON	February:2018	22908
20	INACTIVE	March:2018	50000
21	WON	March:2018	14535
22	WON	April:2018	16349
23	LOST	April:2018	37768
24	INACTIVE	May:2018	20784
25	INACTIVE	June:2018	31750
26	WON	June:2018	9261
27	INACTIVE	July:2018	21850
28	WON	July:2018	18126
29	WON	August:2018	48550
30	INACTIVE	August:2018	36778
31	WON	September:2018	110879
32	INACTIVE	September:2018	109580
33	INACTIVE	October:2018	118458
34	WON	October:2018	137143
35	LOST	October:2018	41000
36	INACTIVE	November:2018	25250
37	WON	November:2018	16631
38	INACTIVE	December:2018	1900

Sheet: Table1

Here is the Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Quote #", Int64.Type}, {"Customer", type text}, {"Industry", type text}, {"Qty", Int64.Type}, {"Product", type text}, {"Accessories", type text}, {"Approx. Value", Int64.Type}, {"Quoted Date", type date}, {"Won Date", type date}, {"Status", type text}}),
    #"Inserted Month Name" = Table.AddColumn(#"Changed Type", "Month Name", each Date.MonthName([Quoted Date]), type text),
    #"Inserted Year" = Table.AddColumn(#"Inserted Month Name", "Year", each Date.Year([Quoted Date]), Int64.Type),
    #"Inserted Merged Column" = Table.AddColumn(#"Inserted Year", "Month:Year", each Text.Combine({[Month Name], Text.From([Year], "en-US")}, ":"), type text),
    #"Grouped Rows" = Table.Group(#"Inserted Merged Column", {"Status", "Month:Year"}, {{"Totals", each List.Sum([Approx. Value]), type nullable number}})
in
    #"Grouped Rows"

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

Have you looked at the Power Query solution? It does start in May 2017. If you only want the "Won" then you can filter out the other categories.

but some of the other things in there weren't working.

Care to elaborate on this?