Home / Discussions

Reply to Message

Another way
Personally, I would use =SUMIF(A2:A9,MAX(A2:A9),C2:C9). This has the advantage that if the maximum date occurs twice in the date column, the total is deleivered rather than just the value for the first occurrence
Posted by DBlayney
2nd May 2012