Excel Date Dependant Sum Range

[Dawber]

I have numerous rows of data in date headed columns (See A14 below for example).

[tab][tab] A[tab][tab][tab]B[tab][tab][tab]C[tab][tab][tab]D[tab][tab][tab]E[tab][tab][tab]F
1 25/01[tab] 01/02[tab] 08/02[tab] 15/02[tab]<Today >Today
2[tab][tab]2[tab][tab][tab]1[tab][tab][tab]3[tab][tab][tab]2[tab][tab][tab]3[tab][tab][tab]5
3[tab][tab]1[tab][tab][tab]3[tab][tab][tab]2[tab][tab][tab]1[tab][tab][tab]4[tab][tab][tab]3
4[tab][tab]5[tab][tab][tab]4[tab][tab][tab]2[tab][tab][tab]2[tab][tab][tab]9[tab][tab][tab]4

I would like to have two additional columns which sum the corresponding values, depending on today's date (See columns E and F above, based on a date of 04/02).

 

[combo]

Formula in E1 (similarly F1):
[tt]=SUMPRODUCT(--(A11<TODAY()),A22)[/tt]

combo

 

[Dawber]

Thanks combo, exactly what I was after.

 

[SkipVought]

ONE formula for each column...
[tt]
E2: =SUMPRODUCT(--($A$1:$D$1<TODAY()),$A2:$D2)
F2: =SUMPRODUCT(--($A$1:$D$1>=TODAY()),$A2:$D2)
[/tt]
code in E2&F2 respecively & copy down thru rows.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]