sum only values in every winter season

[uqls]

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.

[HansDouwe]

One way: Please try in E2 and copy down:

Please Login or Register  to view this content.

[uqls]

Perfect! Thank you

[avk]

With Pivot Table. Refer attach file.

[HansDouwe]

You are Welcome!

Thanks for the feedback and rep . Glad to have helped.

[Czeslaw]

Power Query

Please Login or Register  to view this content.

and formula

Please Login or Register  to view this content.

[Czeslaw]

Another variant Power Query

Please Login or Register  to view this content.