Sum and today functions

[Luis Serpa]

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 column G until today - 1. How do I translate that into Excelese? Or "Sum all values on column G

Thanks in advance.

Luis Serpa

[#2]

@Luis Serpa That could be something like:

=SUMIF(A2:A32,"<="&TODAY()-1,G2:G32)

[#3]

Thank you, @Riny_van_Eekelen . It worked like a charm.