Sum and today functions

Hi all,   In column A I have the dates of the month, one day per row; on my column G I have values. I would like to sum the values on column G until yesterday. Something like: sum all values on col...