Got it:

with cte as

(

SELECT Database, MONTH(Date) AS Month, max(Size) AS Size

FROM DatabaseSize_Archive

WHERE Server = 'CS1'

GROUP BY MONTH(Date)

)

SELECT Month, SUM(Size)

FROM cte

GROUP BY Month

ORDER BY Month DESC