SUM values to today()

[Maurizio]

Hi all,
I have this data: [eu format (dd/mm/yy)]

10/08/21 | 500 | 10/09/21 | 1500 | 11/10/21 | 2500 | 11/11/21 | 3000 | 11/12/21 | 2500 | 11/01/22 | 1500 | 11/02/22 | 1000 | 11/03/22 | 1500 | 11/03/22 | 1000 | 11/03/22 | 500 |

I need a formula that give me 7500 ossia sum all values that have expired as of today

Tia. Maurizio

 

[Fluff]

Are those values in one cell, across a column or what?
It would help if you posted some sample data, so we can see

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Maurizio]

Those values are spread across twenty columns

 

[Maurizio]

so:

 

[Fluff]

How about

=SUMIFS(B1:T1,A1:S1,"<="&TODAY())

 

[Maurizio]

I get 408549 instead 7500

 

[Fluff]

Ok, how about

=SUMPRODUCT((A1:S1<=TODAY())*(ISODD(COLUMN(A1:S1))),B1:T1)

 

[Maurizio]

Ok, how about

=SUMPRODUCT((A1:S1<=TODAY())*(ISODD(COLUMN(A1:S1))),B1:T1)

Simply perfect! Thnks

 

[Fluff]

You're welcome & thanks for the feedback.