Hi all -

After years of searching for answers here, I'm finally creating an account on this forum just to ask this question! I am trying to use a Sumproduct to calculate the sum of an array, for all columns with date < today(). However, I want to ignore the columns I have for annual totals. With the below example, my current formula is Sumproduct($A$2:F$4*($A$1:$F$1<=today()). I need to add one more criteria to ignore the total rows. So far, I've tried the following with no success:

- individual criteria to ignore each total column (e.g., *($A$1:$F$1<>"18 Total")
- renaming all the total columns to be the same (e.g., "Ignore") and adding criteria as a whole to ignore total columns

My table is set up as the following:
A B C D E F
1 10/1 11/1 12/1 '18 Total 1/1 2/1
2 1 2 2 5 2 2
3 3 3 3 9 9 9
4 1 5 11 17 11 11

Any suggestions would be much appreciated!