Prova cosi':

$query = "SELECT SUM(importo) AS tot, mese FROM archivio WHERE mese='agosto' GROUP BY mese";
$Result = mysql_query($query,$db);
$row = mysql_fetch_assoc($Result);
echo $row['mese'];