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 réponses

Epson printer prints unexpectedly

Texture issues in enshrouded

Announcement: online source code archive

Samsung tv music on startup

Écrire o barré avec un clavier azerty

Application extension issue on ps4

Orange unlimited numbers

Text messages from 36111

Tomb raider anniversary on wii

Notice shows wr30 m