Sumproduct - Date criteria to exclude total columns

Originally Posted by no_mouse

Sumproduct($A$2:F$4*($A$1:$F$1<=today()).

For that formula, specifically, totals columns will be ignored anyway because any text value is deemed to be > than any number