Sum and today functions

Question

Hi all,&nbsp;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 GThanks in advance.&nbsp;Luis Serpa

riny_van_eekelen · Answer

Luis Serpa&nbsp;That could be something like:=SUMIF(A2:A32,"&lt;="&amp;TODAY()-1,G2:G32)&nbsp;

luis serpa · Answer

Thank you,&nbsp;Riny_van_Eekelen&nbsp;. It worked like a charm.

Forum Discussion

Sum and today functions

Share

Resources