sum only values in every winter season

Hi
Please can you help me .
My spreadsheet is like this (please see the attached) :

1. Column A : Dates ( Every day's Date ) :
2. Column B : Data numbers (daily value)
3. Column C: Month code
4. Column D: Season
3. Column E : Is where I want the formula to be: (sum only values in every winter season)

The formula must look at column D and add up the corresponding data in column B and give me column E for example.

So basically I need to get a sum only winter season from C2 and so on.

Thanks for your time and help.

Perfect! Thank you

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}, {"Value ", type number}, {"Month", Int64.Type}, {"Season", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Season"}, {{"Sum every winter season", each List.Sum([#"Value "]), type nullable number}}),
    #"Removed Top Rows" = Table.Skip(#"Grouped Rows",1),
    #"Removed Columns" = Table.RemoveColumns(#"Removed Top Rows",{"Season"})
in
    #"Removed Columns"

and formula

Formula:

=SUMPRODUCT((Table1[Season]="Winter")*Table1[[Value ]])

Another variant Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}, {"Value ", type number}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Date", "Date - Copy"),
    #"Extracted Month" = Table.TransformColumns(#"Duplicated Column",{{"Date", Date.Month, Int64.Type}}),
    #"Extracted Year" = Table.TransformColumns(#"Extracted Month",{{"Date - Copy", Date.Year, Int64.Type}}),
    #"Added Conditional Column" = Table.AddColumn(#"Extracted Year", "Custom", each if [Date] < 6 then "Summer" else if [Date] > 8 then "Summer" else "Winter"),
    #"Grouped Rows" = Table.Group(#"Added Conditional Column", {"Date - Copy", "Custom"}, {{"Count", each List.Sum([#"Value "]), type nullable number}}),
    #"Renamed Columns" = Table.RenameColumns(#"Grouped Rows",{{"Date - Copy", "Year"}, {"Custom", "Seaason"}, {"Count", "Sum"}})
in
    #"Renamed Columns"