Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use sumif / Sumproduct for year data
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:B3 6526)) 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif by month and year | Excel Worksheet Functions | |||
sumproduct by year?? | Excel Discussion (Misc queries) | |||
sumif for months and year | Excel Worksheet Functions | |||
sumproduct for month and year | Excel Discussion (Misc queries) | |||
sumproduct in a given year | Excel Worksheet Functions |