I searched through the many MAXIF posts and can not find a solution to my problem. Lets say I have a two column list, first column is date and second column is quantity. What I am looking for if the maximum value from a particular year.
I tried =MAX(IF(YEAR(A2:A12)=2017,B2:B12)) but it returns zero. I think the YEAR(A2:A12) is not valid for a logical compare. Any help on this formula would be appreciated.
My data might look like this:
Year Quantity
04/01/17 9.0
05/25/17 3.0
08/15/17 7.0 Year Max
02/01/18 2.0 2018 0
03/15/18 4.0
05/15/18 5.0
09/06/18 6.0
12/15/18 2.0
01/15/19 9.0
02/15/19 3.0
03/12/19 4.0
and when I enter a year I wan the max to be found in column B for that year.
I tried =MAX(IF(YEAR(A2:A12)=2017,B2:B12)) but it returns zero. I think the YEAR(A2:A12) is not valid for a logical compare. Any help on this formula would be appreciated.
My data might look like this:
Year Quantity
04/01/17 9.0
05/25/17 3.0
08/15/17 7.0 Year Max
02/01/18 2.0 2018 0
03/15/18 4.0
05/15/18 5.0
09/06/18 6.0
12/15/18 2.0
01/15/19 9.0
02/15/19 3.0
03/12/19 4.0
and when I enter a year I wan the max to be found in column B for that year.