Sum and today functions

Copper Contributor

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 Replies

@Luis Serpa That could be something like:




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