C
Chris26
Hi
I have a set of daily data (total rainfall) for100 years.
What would be the easiest way to extract the total rainfall for:-
January Year 2000-2100, February 2000-2100 etc
and also
Total rainfall for 2001, 2002 etc
Col A (Date-Days) Col B (Rainfall mm) Col C (Format to only
show year)
1 Jan 2001 0 2001
2 Jan 2001 6 2001
3 Jan 2001 4 2001
to
31 Dec 2100 20 2100
I have manged to get the following to work
=SUMPRODUCT((TEXT(C3:C36526,"yyyy")="2001")*(B3:B36526)) although is it
possible to change "2001" to a cell ref so dont have to go into each
individual line and cgange to "2002", "2003" etc
Many Thanks
Chris
I have a set of daily data (total rainfall) for100 years.
What would be the easiest way to extract the total rainfall for:-
January Year 2000-2100, February 2000-2100 etc
and also
Total rainfall for 2001, 2002 etc
Col A (Date-Days) Col B (Rainfall mm) Col C (Format to only
show year)
1 Jan 2001 0 2001
2 Jan 2001 6 2001
3 Jan 2001 4 2001
to
31 Dec 2100 20 2100
I have manged to get the following to work
=SUMPRODUCT((TEXT(C3:C36526,"yyyy")="2001")*(B3:B36526)) although is it
possible to change "2001" to a cell ref so dont have to go into each
individual line and cgange to "2002", "2003" etc
Many Thanks
Chris