I'm having trouble with the following SUMPRODUCT formula:


=SUMPRODUCT((B:B=Q3)*(F:O))

The problem is that column F has a text header in cell F2 titled "Initial Value." The rest of the columns have mm/dd/yyyy headers, so SUMPRODUCT works fine there.

Of course, the simplest solution is to just delete the text header in column F, and the formula works fine, but I'm stubborn and want my headers the way I want them.

Does anyone know of a way to get SUMPRODUCT to ignore the text header in cell F2?

Thanks!
Steve