How to separate months and seasons from daily data

[mostafa.elnazer]

Hi guys,

I'm wondering if there a method to separate months and seasons from daily data when the data is huge (Daily data for 150 years and maybe more for more than 50 parameters) ...

I have attached an example of the data below ...

Thanks in advance ...

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[mostafa.elnazer]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

I have attached the example file now with the original post ... Thanks

[kvsrinivasamurthy]

What is the expected result. Manually type them in separate sheet and upload file.

[mostafa.elnazer]

What is the expected result. Manually type them in a separate sheet and upload the file.

Ok, attached is the expected results format worksheet ... With Thanks ...

[JohnTopley]

Deleted by Jt

[mostafa.elnazer]

Deleted by Jt

what do you mean ?

[JohnTopley]

What are the dates defining the seasons?

[mostafa.elnazer]

What are the dates defining the seasons?

Winter (12,1,2)
Spring (3,4,5)
Summer (6,7,8)
Autumn (9,10,11)

[JohnTopley]

I have added helper columns in "ALL" columns U:W which have Year, Month, Season

Named range MS has Mont/Season

in AK3 of "Expected Results"

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$F:$F,">"&$J$2)


In AL3

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$F:$F,">"&$J$3)

in AM3

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$G:$G,">"&$J$4)

in AN3

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$G:$G,">"&$J$5)

copy/paste to other months

For seasons change test for MONTH to SEASON

in S3

=COUNTIFS(all!$U:$U,$AJ3,all!$W:$W,S1,all!$F:$F,">"&$J$2)

[mostafa.elnazer]

I have added helper columns in "ALL" columns U:W which have Year, Month, Season

Named range MS has Mont/Season

in AK3 of "Expected Results"

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$F:$F,">"&$J$2)


In AL3

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$F:$F,">"&$J$3)

in AM3

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$G:$G,">"&$J$4)

in AN3

=COUNTIFS(all!$U:$U,$AJ3,all!$V:$V,MONTH(AK1&0),all!$G:$G,">"&$J$5)

copy/paste to other months

For seasons change test for MONTH to SEASON

in S3

=COUNTIFS(all!$U:$U,$AJ3,all!$W:$W,S1,all!$F:$F,">"&$J$2)

Thanks a lot ... that's great ... I appreciate it Bro.