SUMIF less than or equal to today! Solved

Question

Hello, Who can come to my aid?... I am looking to calculate a sum IF the date is less than or equal to "today()". Thank you for your insights. Best regards.

Grincheux10 · Accepted Answer

Pffff !... finally it's even simpler with the Mazzaropi formula,   = SUMIF(A1:A10,"

Mazzaropi · Answer

Grumpy10, Hello.  A1 = date  G1 = IF(A1

Grincheux10 · Answer

Good evening, That's not quite it. I am trying to sum the values in "B1:B10", knowing that in "A1:A10" I have dates that are both prior to and after "today()". I'm struggling...

jerome9359 · Answer

you create a third column: C1: =IF(A1

Mazzaropi · Answer

Grincheux10, Good evening.  "...I'm trying to calculate a sum IF the date is less than or equal to "today()". ..."  A1:A10 = date B1:B10 = value  G1 = SUMIF(A1:A10;"<="&TODAY();B1:B10)  Was this what you wanted? I hope I helped.  -- Belo Horizonte, Brazil. Marcílio Lobão

Grincheux10 · Answer

Yeeesssss !  and I do B11=sum(C1:C10) and I hide column C! ...  ... and me who was looking with "SUMIF and SUMPRODUCT! ... There are times when we really make things harder for ourselves!!!  Thank you

SUMIF less than or equal to today!

6 answers

My pc boots into bios with windows 11

Machine wash instructions

Samsung note 9 update to android 11 for watch ultra 25

Flood of emails about tracking pixels: new regulation at fault

How to free up space on the c drive

Apps and sites to stay updated on wildfires live streams

Thunderbird is no longer accessible

Samsung tv hdmi ports

Thunderbird won't start anymore.

Unable to sign in to my account